Paste Errors table

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Thanks for taking the time to read my question.

I'm using the TransferSpreadsheet function in MSAccess2000 to import info
from a .csv file.

Until now, I've not had a problem, but now there is apparently one record
that is causing a problem. I can't seem to figure out how to tell which
record is the problem.

When you use the File - Get External Data - Import menu option, and there
are bad records, it puts them into a table called Paste Errors.

How can I do that with my code, so I can see which record is causing the
problem?

Thanks,

Brad
 
Hi,
it could be some conversion error, say you trying to import text into date
field. I suggest that you import whole file into temp table with text
fields, then you can check all fields for proper types, show wrong records
to user and then import the rest using Append query

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Hi Alex,

Thanks for the reply, It was actually a problem of a duplicate record based
on my Index for the table.

So there is now way to make the problem records go to a temp table like a
"Paste Errors" or "Import Errors" table and import the rest of the data?

Brad
 
Back
Top