Skip one row

[winterland]

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]

Write a query and exclude it.
Import the query.
--
Joe Fallon
Access MVP

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.

 

[jing]

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.