How do I import data from an Excel file into an Access Database?

Question

I have the data imported but it wont go into the file. It's just connected as a list of some sort.

Answer 1

If it's "connected", then You probably hit "LINK" instead of "IMPORT". After the IMPORT it will be a new Table which you can work with in Access. Changes made in ACCESS won't effect the original file, since You basically make a copy of the Excel File in the ACCESS DB.

Also, Access IMPORTS and/or LINKS to only ONE WORKSHEET (Tab) at a time. Make sure you have the right Worksheet selected.

If it is "LINKED" you would be able to read the file, but ACCESS won't write to Excel files through the LINK. You would have to IMPORT it and then EXPORT the modified data under the same file name.

Answer 2

The following is copied from the Microsoft Online Help:

1. Make sure the Microsoft Excel data is in list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
2. Close the Excel workbook that contains the data you want to use in Microsoft Access.
3. In Access, open the database where you want to copy the Excel data.
4. On the Access File menu, point to Get External Data, and then click Import.
5. In the Import dialog box, click Microsoft Excel in the Files of type box.
6. In the Look in list, locate the file you want to import, and then double-click the file.
7. Follow the directions in the Import Spreadsheet Wizard.


You are going to either import the data into a New Table or append it to an existing table. If you choose a new table, then a table will be created with the data from the Excel Sheet. If you choose to append to an existing table, all of the columns must line up correctly or it won't work.

I hope this helps.

Answer 3

Open the Excel file.
File, Save as
for filetype, select CSV format (comma separated value)

Open Access
Import the CSV file

should read right in.

Answer 4

I merely now tried replica pasting each and each column from excel to get entry to. suggestions you i had sixteen,000 rows in it and it hardly took 2 minutes. Why pass in the path of the soreness of writing a software?