T
Tony Williams
I have imported a file from Excel into Access 2007 but have got a number of
"Type Conversion Errors" on a number of the records. The columns in Excel
are formatted as dates and some of the data has been imported successfully
whilst some hasn't. I've checked the data in the problem cells in the
spreadsheet and they all appear to be OK they look like dates and are shown
as formatted as dates. So why aren't they being imported? Can anyone suggest
anything I can do to resolve what the problem is?
Thanks
Tony
"Type Conversion Errors" on a number of the records. The columns in Excel
are formatted as dates and some of the data has been imported successfully
whilst some hasn't. I've checked the data in the problem cells in the
spreadsheet and they all appear to be OK they look like dates and are shown
as formatted as dates. So why aren't they being imported? Can anyone suggest
anything I can do to resolve what the problem is?
Thanks
Tony