Browse to identify path of .xls file to import

[Mark Weiler]

I am running an Access 97 database and I am going to need
to import data on a regular basis from an Excel
spreadsheet file into a table in Access.

I am going to use the DoCmd.TransferSpreadsheet acImport,
command.

However the filename and path of the Excel file are going
to change each time.

How can I programatically have the user Browse to the file
they want using a Browse Dialog Box and then capture the
file name and path they browse to in a variable?

Thanks if you have an answer!

Mark Weiler
Ontario Canada

 

[Ken Snell]

You can use the "OpenFile" dialog box from Windows to
navigate to the file (instead of the InputBox). The code for doing this is
a bit complex, but is available at The ACCESS Web:
http://www.mvps.org/access/api/api0001.htm

 

[Cheryl Fischer]

There is code to do just what you want at:

http://www.mvps.org/access/api/api0001.htm