Linking Several Excell Worksheets

  • Thread starter Thread starter Trevor Aiston
  • Start date Start date
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?
 
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.
 
Back
Top