How do I link an excel spreadsheet? 1

[seawave]

Can someone help me with how to link an excel spreadsheet
to use with my Access db. It is a very large file
(20k lines). I thought it would be better to link the file
instead of importing it as a table.

Thank you.

 

[ajdesalvo]

In the database window, select File, Get External Data, Link Tables.

Then in the "Files of Type" lookup list on the bottom of the dialog box, select "Microsoft Excel (*.xls)"

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[seawave]

Thanks, I'll give that a try.