how can I import data into access as part of a macro

[Andrew Fox]

I am trying to build a macro based on a command box that will open an import
wizard screen which will allow me to select which file I want to import and
then proceed through the rest of the import process based on predefined
criteria (ie column headings in first row, import to existing file). After
that I need to run two additional queries which have been set up to append
data to another table and empty the original table the data was imported into.

I have only used the macro feature in Access 2002 to a basic level

Any help would be really appreciated!!!!

 

[Frank Stone]

hi,
use the transferspreadsheet method.
but it wont open a dialog box for you. you just specify
that when you use the transferspeadsheet.
the other 2 querys can be added to the macro
openquery i think.
Regards
Frank