Accessing Excel Data from Access

C

Codeboy

I have a need to import information from a spreadsheet to my database.
Specifically I need to enter an address into access and have it look up that
address on the spreadsheet and import the apn number. HELP
 
D

David Lloyd

One alternative would be to link the worksheet into Access and then write a
query to return the apn number given input parameter(s) with the address.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a need to import information from a spreadsheet to my database.
Specifically I need to enter an address into access and have it look up that
address on the spreadsheet and import the apn number. HELP
 
Top