Excel into Access

[web_time]

I need to import Excel into Access, overwriting the
existing table, but keeping the same structure. I DO NOT
want to append, which is what tranfer does. Any thoughts?

Also, can import a CSV without having to convert it first
to XLS?

 

[Nikos Yannacopoulos]

1. Before Transfer or Append, run a simple delete query (or the equivalent
code) to clear the table. Automate both in one user step (macro or code).

2. Yes, you can. Do it once manually (File > Get External Data > Import)
just so you create and save an import specification. Then you can use the
spec to import either through a macro or through code.

HTH,
Nikos