Ah I look forward to the day when I understand half the answers you kind gentlemen are providing. I feel bad pursuing this but it should seem simple. I want to upload a spreadsheet to two, different, tables and then execute a query. I made as simple macro with Runcommand in the ACTION column and IMPORTATTACHEXCEL in the arguments column. When I run the macro, it does start the import of the file to the table but I have to make all the selections. I suspect there is a way of entering the parameters for this command or using a different command to execute the 2 saved uploads and the query. Just trying to learn the basics here and I DO appreciate the help. Thanks Jan
--- On Mon, 1/12/09, Tyrone Lumley <[email protected]> wrote: From: Tyrone Lumley <[email protected]> Subject: Re: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import of Excel to a table? To: [email protected] Date: Monday, January 12, 2009, 11:55 PM 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 <phssthp...@yahoo. com> wrote: From: Jan <phssthp...@yahoo. com> Subject: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import of Excel to a table? To: ms_acc...@yahoogrou ps.com 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] [Non-text portions of this message have been removed]
