Import data from excel into access tables

[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

 

[Roger Carlson]

Try this:

Link each of the Full Recon tabs into your database. Name then sequentially
(Full Recon 1, Full Recon 2. etc). Then create a UNION ALL query which will
put them all together.

Select * From Full Recon 1
Union All
Select * From Full Recon 2
Union All
Select * From Full Recon 3
....etc.

The create either a MakeTable query (if you want them in a New table) or an
Append Query (if you want the data appended to an existing query) using the
Union All query as the table name.

If you're doing this on a regular basis, all you have to do is overwrite you
Excel spreadsheets with new files and run your final query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Boss]

Thanks Roger,

Idea sounds goos to me..
will do this and let u know over the results..

Boss