Skip one row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to import a table about 4 million records. The error message shows error for row 300,000, "column delimiter not found". Any way to skip that bad record? Thanks.
 
Write a query and exclude it.
Import the query.
--
Joe Fallon
Access MVP



winterland said:
I want to import a table about 4 million records. The error message shows
Click to expand...
error for row 300,000, "column delimiter not found". Any way to skip that
bad record? Thanks.
 
Joe Fallon said:
Write a query and exclude it.
Import the query.
--
Joe Fallon
Access MVP




error for row 300,000, "column delimiter not found". Any way to skip that
bad record? Thanks.
Click to expand...
 
You must log in or register to reply here.

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

Unparsable Record 1
CSV Import with duplicate field names 3
Office 2007 Access import failure 1
Question 3
Import errors importing Text into existing table, header vs no hea 3
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
No error on docmd.transfertext when expected 1
Search Key Not Found? 4

Back
Top