File Import

[jeff1]

I have created a simple macro that imports a space delimited file. How can I modify the macro to ask what file you want to import each time that the macro is run, the file name and path will be different each time.


Thanks to all

Jeff

 

[Aivars]

Hi!

dim strPath as string
strPath = "C:\MyLocation\MyTableDelimData.txt"
DoCmd.TransferText acImportDelim, "MyTable Import Specification", "MyTable", strPath

Aivars

 

[Store300]

MyFile = InputBox([MyMessage], "Please enter the name of the file..etc&quot

And then use the MyFile variable to build up your string.
Store300

Store300@ftnetwork.com