Was unable to Append all the data due to....

  • Thread starter Thread starter google3luo359
  • Start date Start date
G

google3luo359

Hello,

I am using the following code to import data into a temp table.

DoCmd.TransferText acImportDelim, "StudentsCSVis", "StudentsTemp",
"c:\StudentsCSV.txt", False

The code works as it should and everything is fine and dandy, but when
I add "DoCmd.SetWarnings True" I receive the error message in the
title of this thread, with more details of the error just below:

"The contents of fields in 0 record(s) were deleted and 0 record(s)
were lost.
If data was deleted...
If records were lost..."


What are the ways that I can troubleshoot why I'm receiving this
message?
I checked the ImportSpec file. Its field types match those of the Temp
table.
Just for the heck of it I removed the Primary key of the Temp, but
still received the same error message.

TIA Ric
 
the way I see it, there is no problem with zeros ... when
the number is greater than zero, there was a problem

you only got the message because you asked for it...

if the data is good, why worry? you should not have
Warnings on when you are updating anyway

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
strive4peace said:
the way I see it, there is no problem with zeros ... when
the number is greater than zero, there was a problem

you only got the message because you asked for it...

if the data is good, why worry? you should not have
Warnings on when you are updating anyway
Click to expand...


Thanks Crystal. No more worrying from me on this one! :)

Ric
 
you're welcome, Ric ;) happy to help

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.TransferText 9
Unable to Append All the Data to the Table 3
Import CSV file 2
Moving data from one table to another 7
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Allen Browne's Audit Trail code, Run-time error '3825' 6
VBA Recordset problem 2
Unable to Append Imported data 1

Back
Top