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
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.
 
Back
Top