I need help putting an excel spreadsheet into an access database...?

Question

I want to use the contact management template available for access...but I am having difficulty importing the spreadsheet info into it...help!

Answer 1

Excel – Access − Exchange, Import, Export Data
http://office.microsoft.com/en-us/excel/HA100963001033.aspx
There are several ways to exchange data between Microsoft Office Access and Microsoft Office Excel.
· To bring data into Excel from Access, you can copy data from an Access datasheet and paste it into an Excel worksheet, connect to an Access database from an Excel worksheet, or export Access data into an Excel worksheet.
· To bring data into Access from Excel, you can copy data from an Excel worksheet and paste it into an Access datasheet, import an Excel worksheet into an Access table, or link to an Excel worksheet from an Access table.
Note:
· The word import has two different meanings between Excel and Access. In Excel, the word import means to make a permanent connection to data that can be refreshed. In Access, the word import means to bring data into Access once, but without a data connection.
· You cannot save an Excel workbook as an Access database. Neither Excel nor Access provides functionality to create an Access database from Excel data.
*******************************
Excel to Access
Excellent link. A tad long. Will explain everything.
http://office.microsoft.com/en-us/access/HP010950951033.aspx

Answer 2

Just open it with Access......it will do its best to integrate the data and then you just go in and fix it up....

FILE>OPEN
make sure the file type is set to xls files...

Answer 3

Write VBA code, using ADO.