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

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/...UBED1=ACCESS-L

"Boss" <(E-Mail Removed)> wrote in message
news:286BF21E-7356-4574-9659-(E-Mail Removed)...
>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
>
>

Thanks Roger,

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

Boss

"Roger Carlson" wrote:

> 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/...UBED1=ACCESS-L
>
> "Boss" <(E-Mail Removed)> wrote in message
> news:286BF21E-7356-4574-9659-(E-Mail Removed)...
> >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
> >
> >
>
>
>