bring multiple Excel data sheets to Access

[PrinStation]

I am looking to import data from Excel to Access. The data is set up in one
Excel file, but on 12 (monthly) sheets. After importing the first month/sheet
(which I did successfully), I was looking to use the old dBase 3 plus command
"append" to bring in the eleven remaining sheets. I am thus far unable to find
"append" or rather its Access equivalant. What to do? Any help is appreciated.

[Tom van Stiphout]

On 18 Nov 2003 02:13:37 GMT, pr*********@aol.com (PrinStation) wrote:

Use File / Get External Data / Link Tables to link to a worksheet. Do
it 12 times to link to all.
Then write append queries (see help file) to add the data to your
table.
Note: Access is not Excel. Do not create 12 tables, but one. Add an
additional InvoiceMonth (or whatever) field.

-Tom.

I am looking to import data from Excel to Access. The data is set up in one
Excel file, but on 12 (monthly) sheets. After importing the first month/sheet
(which I did successfully), I was looking to use the old dBase 3 plus command
"append" to bring in the eleven remaining sheets. I am thus far unable to find
"append" or rather its Access equivalant. What to do? Any help is appreciated.

[PC Datasheet]

How about creating 12 Access tables where each table links to one of the
worksheets. Next write a Union query that combines all twelve tables. You can
then write whatever queries you want against the union query. Doing this makes
your integrated Excel/Access application permanent and you won't have to but
once set it up.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"PrinStation" <pr*********@aol.com> wrote in message
news:20***************************@mb-m15.aol.com...

I am looking to import data from Excel to Access. The data is set up in one
Excel file, but on 12 (monthly) sheets. After importing the first month/sheet
(which I did successfully), I was looking to use the old dBase 3 plus command
"append" to bring in the eleven remaining sheets. I am thus far unable to find
"append" or rather its Access equivalant. What to do? Any help is appreciated.