A few words of thanks would be greatly appreciated.

Importing an Excel table into Access


I would like to automate the import of an Excel table to Access.
A field of writing will give me the path of the excel table and a button will launch the import. I am wondering how I should go about it. What is the code that can allow me to do this?


Access - Converting an Excel file into Access? This can be very useful for the persons having a mailing list on Excel and wishing to import it into an Access Database....
  • Open a blank Access database and name it.
  • Select the File menu, then External Data and select Import.
  • In the File Type dialog box opens, select xls and select your Excel file.
  • Your Excel file is probably present in the form of a table: check First row containing column headings.
  • Click the Next button.
  • On the next screen, select option 1 :"Store my data in another table".
  • Excel will ask you to name each column in your table and assign an index (perhaps not to import the particular column): select a column, click on its header. Indexes only the fields you're likely to do some research.
  • Then click "Allow Access to choose the primary key".
  • Name your table and check the box, the wizard analyzes the structure of the table after importing the data.

Thus, if Access often meet the same data, to save resources, it will offer to create linked tables.
Simply follow the instructions to complete the process.

Thanks to <a href='http://www.commentcamarche.net/forum/affich-18408352-importation-de-table-excel-sous-access
'>olimix</a> for this tip.....

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Published by . Latest update on by deri58.

This document, titled "Importing an Excel table into Access," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).