Macro/Cmd to Import Excel file into Access
Posted on 2010-09-14
I have a temp table in Access that I import data into and then (based on various criteria) append to a second table.
I'd like to automate the import process into the temp table. Currently I delete current records and then go through the import wizard, etc, etc. I'm planning to use a macro and can use all the STD commands fir deleting current records and running update/append queries. My issue is the import of te Excel file. Is there a command or something I can run within the macro to do the import? I will be importing a file with a STD name and set file path location. It will be imported into an existing table. Currently using Excel 2003 but will soon be upgrading to 2010 if that needs to be considered. I am using Access 2000. Thanks.