Importing Excel File into Access using the wizard

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?
 
D

DPirtle

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?
 
J

Jeanette Cunningham

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
 

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

Similar Threads

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Merge Excel file into Word Document 3
Excel - Wich Function should I use? 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top