L
Lloyd
We’re currently using Access 2002 SP3, Excel 2002 SP3 on Windows XP SP2. We
have an Excel spreadsheet we import into Access. Once the import is
complete, the following message appears:
Finished importing file <path> to table <name>. Not all your data was
successfully imported. Error description with associated row numbers of bad
records can be found in the Microsoft Access table '<name>_ImportErrors'.
I looked on Microsoft’s website and it stated something about conversion
errors when you import dates that have different formats.
So in Excel, we formatted the cell with the date to Category: Date, Type
*3/14/2001. We did the import again and still receive the above error.
Does anyone have any other suggestions?
Thanks.
have an Excel spreadsheet we import into Access. Once the import is
complete, the following message appears:
Finished importing file <path> to table <name>. Not all your data was
successfully imported. Error description with associated row numbers of bad
records can be found in the Microsoft Access table '<name>_ImportErrors'.
I looked on Microsoft’s website and it stated something about conversion
errors when you import dates that have different formats.
So in Excel, we formatted the cell with the date to Category: Date, Type
*3/14/2001. We did the import again and still receive the above error.
Does anyone have any other suggestions?
Thanks.