Importing Excel File into Access using the wizard

  • Thread starter Thread starter DPirtle
  • Start date Start date
D

DPirtle

I have a business need to build an access form that prompts the user to
select an excel file with a list of loan numbers using the import wizard,
then import those loan numbers into an Access table.

From there I need to determine the name of the access table and/or the excel
file name so a query can be run against the list of loans.

Any ideas?
 
DPirtle,
to allow users to select the excel file, use the common open save file
dialog.
The code is on the access web.
Here is a link to the code
http://www.mvps.org/access/api/api0001.htm

You might find it easier to link to the excel file instead of importing it.
When you link to the file, it becomes a linked table in your database and
you can query it in the same way as a regular table.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Thanks I will give that a shot. Can I also go the other way, in excel take
and loan number and query against a linked access table to obtain a value?
 
You can certainly link to an access table or query from excel.
In Excel 2003 you go to Data | Import Data.
I won't advise on how to run a query using excel as it's not something I
have tried.


Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top