Import data from excel into access macro

B

Boss

I have 25 excel sheets with same format.
I wish to import the data from all the sheets in one access master table.

I am poor at coding and i am looking for a code which can do the following.
Import data from all the excel sheets kept in c:/ drive into one master table
in ms access.

The excel sheets have many worksheets but i am only looking fot the first
worksheet data named as "Full recon"

Their is nothing similar in the filenames of the 25 excel sheets, onty the
format is same.

Thanks a lot for the help in advance.
Boss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from excel into access tables 2
Embed the same Excel multiple times 0
Creating a Chart on form from selected data in query. 0
Import all excel files in a particular folder into one master tabl 4
Adding data to MS Access from csv file 0
Paste to excel from word - auto format problem 1
Excel Import Specification 2
Importing Excel multi tabs into Access 2

Top