Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 963
  • Last Modified:

Unable to Append All Data to a Table in Access 97

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...

mv
0
Michael Vasilevsky
Asked:
Michael Vasilevsky
1 Solution
 
Michael VasilevskySolutions ArchitectAuthor Commented:
Ah, I solved my problem: just allow zero length string on all text fields.

Does that mean I get the points?
0
 
flavoCommented:
Sure does.. well done, no seriously post a 0 point Q in the Comunity Support TA and tell them you solved the Q yourself.  Make sure to leave a link back to here for them.

Dave
0
 
ee_ai_constructCommented:
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now