ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excell 2000 to access 2000 (https://www.excelbanter.com/excel-programming/280266-excell-2000-access-2000-a.html)

vinimall[_2_]

excell 2000 to access 2000
 
how do I import data from excel 2000 into Access 2000 so I can use the
data in an Access Querie??


vin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


Robert Nicholson

excell 2000 to access 2000
 
You need to open Access, and then use the File menu and the Get External
Data and Import. You can then select the file type to import.

Robert

"vinimall" wrote in message
...
how do I import data from excel 2000 into Access 2000 so I can use the
data in an Access Querie??


vin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/




Tom Ogilvy

excell 2000 to access 2000
 
In the file menu of Access, look at the import command.

--
Regards,
Tom Ogilvy
"vinimall" wrote in message
...
how do I import data from excel 2000 into Access 2000 so I can use the
data in an Access Querie??


vin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/





All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com