I posted my solution but I guess that it did not come through to my email. please check the user group for my solution.
Jim Wagner ________________________________ ________________________________ From: Tyrone Lumley <[email protected]> To: [email protected] Sent: Monday, January 12, 2009 9:55:32 PM Subject: Re: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import of Excel to a table? 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]
