Solved

Unable to Append All Data to a Table in Access 97

Posted on 2004-10-18
3
947 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

821 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