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 <tyrone_topheavy@...>
To: ms_access@yahoogroups.com
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 <phssthpok3@yahoo. com> wrote:

From: Jan <phssthpok3@yahoo. com>
Subject: [ms_access] Does Macro Runcommand: ImportAttachExcel alllow the import
of Excel to a table?
To: ms_access@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]