Importing multiple files

[Jessica]

Greetings!

I want to use VBA to automate the import of fixed width
files (docmd.TransferText), but the file that will be
imported will always be changed. How do I allow the user
the flexibility to chose which file that should be
imported? All the files have the same format and I have
set the specs for that format, but the actual file will
constantly change. Is there anyway to allow the user to
type in the file location or maybe have a drop down box
that allows them to search for the file location??

Any help would be appreciated!

thanks!

Jessica

 

[Graham Mandeno]

Hello Jessica

You can allow the user to choose the file via the built-in File Open dialog
box. There is some example code at
http://www.mvps.org/access/api/api0001.htm