Read From Excel Sheet

[Ice Man]

Hi All

what is the best strategy?


I have a program that must search for a given Code to get model and serial
number and print them on a paper

the information is contained in an excel sheet

for ex.

Code model S/N
123 KL-MV/09 213423-2340
456 MO-P/34 329847-2545
.... ............. ......................



waht is the best strategy to proceed...
is it by reading directly from excel.... or exporting this excel sheet to a
tab delimited file then read from it... or import it to an access table then
read from it!!

Pls note that the import in case it's used, must be done automatically

I appreciate any kind of help

Regards

 

[chas]

Hi Ice man,

you can link an Excel spreadsheet into Access and use it
as if it were a table in Access.

Choose File|Get External Data|Link Table and then
select .xls as the files of type in the dialog box and
browse to your .xls file. You can then choose which
worksheet/named range to link. Once this is done you can
create a query based on it or search as required.

hth

chas