Yes, you can import an Excel spreadsheet using this command. You should have the option of importing to a new spreadsheet, or appending to an exsisting one. I have better luck using VBA, opening an instance of excel using the excel object model, finding the last cell, and using a for-next to import the records. More control, and more professional than a macro calling a wizard....
--- On Mon, 1/12/09, Jan <[email protected]> wrote: From: Jan <[email protected]> Subject: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import of Excel to a table? To: [email protected] Date: Monday, January 12, 2009, 6:01 PM 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]
