How can I transfer information from an Excel spreadsheet to an Access database? Please explain in simple terms

Question

I am creating a new Access database using information I have been keeping on an Excel spreadsheet for years. Is there a way to transfer the data instead of entering it over again?
I am not extremely computer literate, so please explain as simply as possible. I appreciate any and all help you can give.

Answer 1

At the top of the Access page, click on DATA.



Choose IMPORT.



Browse to the Excel spreadsheet, and click IMPORT.



Sit back and be amazed.

Answer 2

From the Access Menu, choose File>Get External Date>link tables. Choose Excel from the file types. Next select your excel document. Access will treat this linked table almost just like a regular table. The advantage here is changes made in either program will be saved. For a one way connection: You can use an ODBC in the Excel sheet to connect to the database. On the Excel menu, go to import external data>New Database Query Choose MS Access Database from the menu. In the dialogue box choose your database and table. Then select the fields you want. Choose Ok. When you want to update the Access data, click on the table in Excel, then go to the Menu and choose date>refresh data. This is one way only. From access to excel. Hope that helps.

Answer 3

From your Access database, click New ->Import Table.

Change Select Files of Types to Excel, select your Excel and Import the sheet you want. From here follow the instructions.

I have made a quick video for you, hope this will help:

http://naimul.huq.name/e/HowtoUploadExceltoAccess/HowtoUploadExceltoAccess.html

Answer 4

It is very easy to do.



Open Access and create a new database.

Open up a new table.



Open up your Excel document.

Select all the rows of data you want to put into Access

"Copy" (Ctrl c) those rows.



Return to your database

Select the last row of the Table(one with the *)

"Paste" (Ctrl V) in the data from Excel



After that you will have label all the fields to make it easier to understand, but your data should all be there.

Answer 5

1st answer is spot on for Office 07.



If you need to do it in an earlier addition, you can click "File" >> "Get External Data" >> "Import". Make sure the drop down menu has Excel File selected.

Answer 6

highlight the info u wanna tranfer then right click it then click on copy then go to where u wanna transfer it then click paste