import excel using script

[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)

 

[DomThePom]

Don't bother to import - create an attached table to the excel sheet then use
this attached table in your queries

 

[Ken Snell \(MVP\)]

You can import data from EXCEL spreadsheet using the TransferSpreadsheet
(macro or VBA). See Help for more details about it.