Importing Excel into Access 97

Neal · Jun 3, 2004

There is no option to Import File. How do you do this in Access 97? Do you
have to use MSQuery or something? I can't remember, it's been so long since
I had Access 97

Thanks, Neal

Arvin Meyer · Jun 3, 2004

Neal said:
There is no option to Import File. How do you do this in Access 97? Do you
have to use MSQuery or something? I can't remember, it's been so long since
I had Access 97

File ... Get External Data ... Import (or link)

then choose the Excel datatype from the list.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access