Import not from 1st row

[GoatieEddie]

Hi all,

Newboy to Access.

I have a csv file that contains three rows at the top that I need to discard (the field names start in row4). Very comfortable as to how to strip these out in Excel but would prefer to keep it tidy and do it all in Access. Is it easily do-able or should I stick to what I know best?

Thanks,
GE

 

[dhookom]

I would import into a temporary table, delete the unwanted rows, and then append to permanent table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]