Browse to identify path of .xls file to import

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top