I am using VB.NET to import data from an XML file and then store it in an Access 2002 database.
I used the Dataset Designer to set up a TableAdapter for a single table which has 6 numeric fields and 2 DateTime fields.
I imported an XML file successfully into the Dataset table.
I attached this table to a DataGridView and saw all the records I expected to see.
The date fields are formatted correctly.
However, when I call the Tableadapter.Update method, my data does NOT get transferred to the Access database table.
I tried trapping exceptions but none occurred.
I tried File, Import,XML in Access and got an error saying the Datetime fields could not be imported and they were left blank when the rest of the data was imported.

This is what the XML data looks like:
<FirstSeen>2005-02-28T00:00:02.4654656-05:00</FirstSeen>

This is what is displayed in the DataGridView FirstSeen column: 01/03/2005 04:55

The FirstSeen column in the Tableadapter has the DateTimeMode property is set to UnspecifiedLocal
The FirstSeen field in the Access database is Date/Time, General Date format

Help!!! Can anyone please tell me more about date/time handling between XML and Access?