Importing into access from excel

[LAS]

I perform many creditors reconciliations in Excel and they are all automated BUT the one of the creditors has become too big for excel.

I would like to keep the excel interface but do the following.

Via excel, import the data (text and .xls files) into a Access database, run some queries on the data and return certain results to Excel.

Running the queries on the Access database and returning the results to excel are not a problem.

THE QUESTION IS, how do I import the data via Excel VBA into a ACCESS data base.

Thanks for your help.

 

[Joe4]

You don't necessarily need to import the data from Excel. You can leave the data in Excel and link the data to Access tables. To do this, go in Access into Tables, right click and select "Link".

The advantage to this is as your data changes in Excel, it will also change in Access.

You can perform queries on linked tables just the same as you would for regular Access tables.

 

[LAS]

I want to automate the import / link process in Access from Excel.

I maybe should automate it from Access itself, but I am more familiar with EXCEL's VBA.