import excel using script

  • Thread starter Thread starter Clemens
  • Start date Start date
C

Clemens

Is it possible to import a excel sheet into access using a script (macro).

I'm not known with scripting, but I hope someone can help me.

I have a 3th party utill without reporting options.
I can export this tool to Excell.
I use Access for reporting, so every week I perform the export, manualy
clear the table in access and import the excel sheet.

I want to start from the switchboard a script that perform these steps, so
clear existing data in table and import the excel sheet (hopefully with
pop-up where to find the excel sheet)
 
Don't bother to import - create an attached table to the excel sheet then use
this attached table in your queries
 
You can import data from EXCEL spreadsheet using the TransferSpreadsheet
(macro or VBA). See Help for more details about it.
 
Back
Top