How link Excel file as append?

[Ian Elliott]

Thanks in advance.
I have a database file that I brought a lot of info from
Excel by copying and pasting (column by column). I figure
it would be more error safe if I did by linking. I have a
workbook with five worksheets, and I would like to append
one after the other into a single Access table. But when I
File>Get External Data>Link Tables>...>Linked Table Name>
and I type the same file name as the one that is already
open, I get an error (already open). Apparently I don't do
it this way to append. Does anyone know how to? The MS
help says:
Notes

You can import or link all the data from a spreadsheet, or
just the data from a named range of cells. Although you
normally create a new table in Microsoft Access for the
data, you can also append the data to an existing table as
long as your spreadsheet column headings match the table's
field names.

My spreadsheet column headins match the table's field
names, but I don't know how to append.
Any ideas?
Thanks again.

 

[fin]

Is Access 2000, you can create a multiple links to a
single Excel file. One for each worksheet you have. You
can select which worksheet when linking. Assuming all the
columns have the same field name and data format(field
names should be of the same data format), you can use an
Append Query to add the data from the Excel worksheets to
the Access Table. You could actually created the table by
using a Make-Table Query from the first worksheet then use
the Append Query for the remaning worksheets.