Excel into Access

  • Thread starter Thread starter web_time
  • Start date Start date
W

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