How can we convert the Excel data table to Access?

 Excel Table is Excel data converted to a table.

Excel application allows you to export excel data in an Excel sheet in two ways.

1. Create PDF/XPS Document

2. Allows you to change the File Type

The following filetypes are possible:

There is no direct way you can go from Excel to Access but there are a number of ways you can do.

Here is a simple procedure of taking Excel data to Access.

We start with a simplest data in a sheeet. Use File|SaveAs and save it as a CSV file shown here.

Create a new database from Access

Now all you need to do is to import into an Access application.

Open the Access database and click on External Data. Now click New Data Source as shown and from going to submneu you can get data from a file saved in several formats incouding CSV. Click on File|Excel.

This opens up 'Get External Data-Excel Spreadsheet'. Browse and select the CSV file you created and accept the default for import, Import the source data into a new table in the current database.

Huh! Editor sucks!!

Click OK. The Import Spreadsheet Wizard comes up showing your data in the Excel sheet.

Click Finish. Your data is in an Access table as shown.

If you need to bring in your data, follow the steps. For problems contact me.