TransferText "Database was unable to append..." message

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Do you have any fields that are Indexed and cannot accept
duplicate values? Also, check your Allow zero length
Field setting properties. Just a wild guess.
-----Original Message-----
Hi all,

I've been trying to figure out this porblem for a week,
Click to expand...
with no luck. Here's my issue...
I am running the following line of code while importing a text file into an table:

DoCmd.TransferText , , strTableName, gStrAppPath + strTableName + "Upload.txt"

If I step through the code the code works flawlessly. If
Click to expand...
I run the code, sonetimes it works fine, sometimes it
throws the following message:
Database was unable to append all the date to the table.
Click to expand...
The contents of fields in 0 record(s) were deleted, and 0
record(s) were lost due to key violations.
I've tried throwing doEvents in all over the code, along
Click to expand...
with timer loops, to try to "give the CPU a break", all to
no avail.
 
Thanks for the tip Kevin. Unfortunately this isn't the problem

But I am noticing something else...It appears when I step through the code all of my .execute "Select * from table" code works, but when I run the code, again...some of the queries don't run

Mighty strange. Again, any and all hep is appreciated

Ken
 
Back
Top