Import steps

[KAnoe]

I have a text file that I import into a table named new data. At this time it
takes the user thru 6 steps with the wizard. I would like to have it set up
so that the user would just need to click a cmd_btn and the import dialog box
comes up with the file type set to txt. Then when the user double clicks txt
file with the new data in it would import that file.

The txt file does have headers and is always in the same format and it goes
to the same table.

bellow is what I do now.

File / Get External Data / Import
Import Menu, Need to set Files Type and path to the file
Import Wizard / First Row Contains Column Heading
In an Existing Table Finish

 

[Ken Snell [MVP]]

Check out TransferText in Help file. It can be used in a macro or in VBA
code to import the text file. It also has an argument that allows you to
specify the name of a stored specification (which you create and save during
one manual import of the file).