Allow user to search for and import an Excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I see that somoe of this has been covered already but when I read the posts
it appears that it is for the most recent version of Access(Access 2007) .

Our office uses Access 2003. I have a user that wants to be able to select
any Excel report and import it into a table into Access. The Excel report
and Access table have the same headers, but the Excel reports may have a date
in the name for archival purposes. Is it possible to find a solution so that
the user can browse for the Excel report and then import the selected Excel
report into the Access 2003 table with the Docmd Transferspreadsheet?
 
First, copy the code at this site:
http://www.mvps.org/access/api/api0001.htm
As paste it into a standard module.

It is what you will use to allow the user to browse for whatever type of
file you want them to. Once they have selected the file, you can use the
variable you populate the the result of the open dialog box in the
TransferSpreadsheet as the file name.
 
Back
Top