Go to options and edit remove the checks from the confirm panel




________________________________
From: Jan Hertzsch <phssthpok3@...>
To: ms_access@yahoogroups.com
Sent: Tuesday, January 13, 2009 9:31:19 AM
Subject: [ms_access] Macro Runcommand: ImportAttachExcel


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 <tyrone_topheavy@ yahoo.com> wrote:

From: Tyrone Lumley <tyrone_topheavy@ yahoo.com>
Subject: Re: [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, 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 <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]



[Non-text portions of this message have been removed]