I'm trying to import excel spreadsheets into an Access 97 (latest version the client has) table using the DoCmd.TransferSpreadsheet command. Some spreadsheets produce the error: "Microsoft Access was unable to append all the data to the table. The contents of field in 0 records were deleted, and 0 records were lost due to key violations." Despite the claim of 0 records, some records are not imported.
The same spreadsheet imports fine if I convert the db to 2002 (XP).
Also, I can "fix" the offending records by deleted the contents of some particular empty (?) cells.
Is this a known bug? Any work around?
Any help would be appreciated.
Boy, I wish my client would just update their software...