Microsoft access how to import data: Step-by-step

Import into a new Access table when the source file is clean and the columns already line up; append to an existing table only when field names, data types, and column order appear to match. Bad matches create truncated values, type errors, duplicate rows, and broken lookups, so check the source before you start.

Go to the External Data tab first. Then pick the source type that fits the file, choose or create the destination table, and verify headers, delimiters, and field types before you run the wizard.

Start here

What you’ll need

• Microsoft Access with the target database open
• A clean CSV, Excel workbook, or tab-delimited text file
• The column names you expect to see in Access
• The field types you expect for each column
• A destination Access table, or permission to create a new one

Should you import or link data?

Import when you need a one-time copy inside an Access table. Link when the source must stay refreshable from Access and you want the external file to remain the system of record. The decision matters because imported rows become local data, while linked data stays external.

Use import for clean snapshots, reporting tables, and staging work. Use link when a workbook or text source changes often and Access only needs read access or controlled edits through the external source.

Choose the right path before you click

1. Open External Data in Access.
2. Select the source type: Text File for CSV or tab-delimited text, or Excel for a workbook.
3. Choose Import the source data into a new table in the current database for a fresh table, or append only when the target table already matches.
4. Pick Link to the data source only if you need refreshable external data.

Suppose a workbook updates every Monday and Access only needs the current sales list. Link it. If the workbook is a one-time delivery that must become an Access table, import it instead.

How do you import a CSV into Microsoft Access?

For a CSV file, use the text-file import path, confirm the comma delimiter, and decide whether row 1 contains headers before you map fields. CSV imports often fail when Access misreads commas, treats headers as data, or converts text IDs into numbers.

CSV import steps

1. Go to External Data > Text File.
2. Browse to the CSV file and choose Import the source data into a new table or append to an existing table.
3. In the wizard, choose Delimited and confirm the delimiter is Comma.
4. Check First Row Contains Field Names if row 1 is a header row.
5. Review the preview screen and verify each column stays in its own field.
6. Map each column to the destination table and finish the import.

Say your CSV contains ZIP codes like 02134. If Access treats that column as a number, the leading zero disappears. Keep it as Short Text in the destination table so the value stays intact.

How do you import data from Excel into Microsoft Access?

For an Excel workbook, choose the workbook file, then choose the worksheet or named range that holds the data. Column headers must map cleanly to Access fields, and mixed data types can trigger conversion issues or nulls when one column contains text and numbers together.

Excel import steps

1. Go to External Data > Excel.
2. Select the workbook and choose whether to import a worksheet or a named range.
3. Pick the table destination, or create a new table if the source is not yet structured for Access.
4. Check that the first row contains unique column headers.
5. Map fields and set data types before you finish the wizard.
6. Open the imported table and scan for merged-cell fallout, hidden-row surprises, and truncated text.

A common first-timer mistake is importing a sheet that has two title lines above the header row. Access reads the first line as field names, then shifts the real data into the wrong columns. Remove extra title rows before import.

How do you import tab-delimited text?

Use the text import path and set the delimiter to tab rather than comma. Tab-delimited files often come from exports that look clean in a text editor but break in Access when the delimiter is wrong or when the file includes extra title rows above the real header row.

Tab-delimited import steps

1. Go to External Data > Text File.
2. Select the .txt or .tsv file.
3. Choose Delimited and set the delimiter to Tab.
4. Confirm whether the file has one header row or multiple title lines.
5. Match each column to the correct Access field type.
6. Finish the wizard and open the table to check for shifted columns.

Access import checklist

Why is my import into Access failing or missing fields?

Most missing-field problems come from the source shape, not the wizard. The usual causes are a wrong delimiter, a header row treated as data, mixed dates in one column, leading zeros that were converted, or a text field that is longer than the Access field size.

Fix the file first, then re-import. If a CSV column contains both dates and blanks, or an Excel sheet mixes numbers and text in the same column, Access may null out values or reject rows rather than guess the correct type.

If that didn’t work, try this next

1. Open the source file in its native program and clean the columns before retrying.
2. Set obvious text fields to Short Text in the destination table.
3. Split mixed columns so each field holds one data type only.
4. Remove merged cells, hidden rows, and extra title lines from Excel sources.
5. Shorten oversized text or widen the Access field before importing again.

Picture a workbook with part numbers like 00125 in one column and 1987 in another. If the same column also contains text such as A17 later in the sheet, Access can misread the whole field. Put part numbers in a text field and keep the column type consistent.

How do you keep imported data from breaking data types?

Match each source column to a destination field type before you finish the wizard. Text, number, date/time, yes/no, and currency fields all need compatible values. When the source mixes formats, Access may reject rows, null values, or store the wrong version of the data.

Keep identifiers as text when they can contain leading zeros or nonnumeric characters. Use date/time only when every row truly contains dates. If one column mixes true dates with notes like “unknown,” split that column before import.

Use the field mapping screen carefully

1. Review the mapping screen row by row.
2. Change any field type that would drop leading zeros or text labels.
3. Rename fields only when the destination table needs different names.
4. Skip columns you do not want in Access.
5. Create new fields only when the destination table does not already have the right structure.

How do you import only selected columns into Access?

Use field mapping to skip columns during the wizard. That is the cleanest way to import only the fields you need without carrying extra notes, formulas, or raw source columns into Access. It also reduces the chance of type conflicts from columns you do not plan to use.

Selected-column import steps

1. Start the import wizard from External Data.
2. Advance to the field mapping screen.
3. Clear the import checkbox for columns you do not need.
4. Rename fields only where the Access table requires a different name.
5. Finish the wizard and open the table to confirm only the intended fields arrived.

Common mistakes

Wrong delimiter selection splits one source column into several Access fields. A header row imported as data creates a bad first record. Mixed date, number, and leading-zero values cause nulls or unwanted conversion. Missing or duplicate keys break relationships after import.

After import, compare row counts between the source and Access, then verify the primary key. If the table feeds relationships or lookups, test those joins before you trust the table for edits or reports. That check catches damage early.

Preflight before you import

• Confirm the file type and choose the matching import path.
• Verify the delimiter for CSV or tab-delimited files.
• Check whether the first row contains headers.
• Make sure every column has one clear data type.
• Remove merged cells, extra title rows, and hidden content from Excel sources.
• Decide whether the destination is a new table or an existing one.

Frequently asked questions

How do I import data into Microsoft Access?

Open External Data, pick Text File for CSV or tab-delimited files, or Excel for workbooks, then choose whether to import into a new table or append to an existing one. After that, map fields, set data types, and finish the wizard.

How do I import a CSV into a Microsoft Access database?

Use External Data > Text File, select the CSV, choose Delimited, and set the delimiter to Comma. Confirm whether the first row contains field names, then map the columns and open the table to check for shifted data.

Should I import or link external data in Access?

Import when you need a local copy that you control inside Access. Link when the source must stay external and refreshable. If the source changes often, linking is the better fit; if you need a static table for editing or reporting, import it.

What file types can Microsoft Access import?

Access can import common spreadsheet and text sources through the wizard, including CSV, Excel workbook files, and tab-delimited text. Easysoft also lists an Access ODBC driver among its DBMS products, says its driver products include Microsoft Access support, and provides a bridge specifically for connecting JDBC to Microsoft Access.