You can write a macro to run your queries.
________________________________ From: Jan <[email protected]> To: [email protected] Sent: Monday, January 12, 2009 6:01:22 PM Subject: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import of Excel to a table? It sure looks like this is the way to go but my book does not talk about this run command. I did a search on the web and got little. I want to set up a macro to import an excel worksheet and overwrite an existing table. I can't figure out the syntax for this. Can you help? [Non-text portions of this message have been removed]
