Linking Several Excell Worksheets

T

Trevor Aiston

I haveto create a link to several excel workinsheets all of which hold
exactly the same type of data. I want to combine the workesheets data in to
one access data table.

Should I use an append query to do this?

Sorry real novice here?
 
J

John Nurick

Hi Trevor,

If you just want to link the data (as opposed to permanently importing it to
an Access table), then

1) Use File|Get External Data|Link to create a linked table for each of the
worksheets.
2) Create a Union query (see Help for more) that combines the data from all
the linked tables.

To import the data, use File|Get External Data|Import to import from the
first worksheet to a new table. Go to Table Design view and if necessary
adjust the field types that Access created so they are what you need. Then
import the remaining worksheets one at a time to t he existing table.
 
Top