Solved

Unable to Append All Data to a Table in Access 97

Posted on 2004-10-18
3
942 Views
Last Modified: 2008-01-09
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
Comment
Question by:Michael Vasilevsky
3 Comments
 
LVL 10

Author Comment

by:Michael Vasilevsky
ID: 12343456
Ah, I solved my problem: just allow zero length string on all text fields.

Does that mean I get the points?
0
 
LVL 34

Expert Comment

by:flavo
ID: 12343718
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
 

Accepted Solution

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

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now