Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i import an Excel 2000 spreadsheet into Access 2000?

Status
Not open for further replies.

Gaff

Programmer
Dec 13, 2001
30
IE
Is it possible to be able to write a sub procedure to automatically import an Excel 2000 spreadsheet into an Access 2000 table? The location of the spreadsheet and its structure will not change and the same applies to the table? If this is possible does anyone have some useful code that i could use. Thanks.
 
In Access, go to Help. Then Index, Import, Import Spreadsheet Wizard. Follow instructions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top