[b]deleting contents[/b] 1

[lars7]

I would like to import an excel file into a table but delete the contents of the table first, can this be done and if so what is the best way.

 

[dhookom]

Run a delete query prior to the import.

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]

 

[lars7]

Thanks that worked