Paste Errors table

[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

 

[Alex Dybenko]

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

 

[Brad]

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

 

[Alex Dybenko]

Hi,
I would try to import data into temp table without index and then check
there for duplicate records, don't know how to get "Paste Errors" or "Import
Errors" table

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