Table Link

[Guest]

I've linked 5 excel spreadsheet in my table.

How do i create ONE merge table from the 5 link excel spreadsheet

Thanks

 

[Jeff Boyce]

We're not there, we can't see what you've done.

What do you mean "linked 5 excel spreadsheets in my table"?

What kind of data is in the 5 excel spreadsheets that you believe belongs
merged together into a single table?

More information, please... more specific descriptions will help us offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi zyus,

Either create a query that links the 5 excel sheets together then use the
"make table" query type to run it;

OR

Import each of the spreadsheets into their own table then create a query as
per above (using the imported tables) to create a new merged table.

Hope this helps.

Damian.

 

[Guest]

In my table i hv this link excel

-> Excel A
-> Excel B
-> Excel C

All excel hv a standard field format..but with different records

I want to merge the excel into one merge table say table ABC and this table
will auto change when user update the excel spreadsheet..

Hope this is clear

 

[Van T. Dinh]

Since you want the data as appear in Access to be updated if the users
change the data in the Excel sheets, you need to use linked Tables and not
import.

Use a Union Query to combine the data from 5 linked Tables into one dataset.

 

[Guest]

Got your msg that i will use linked tables and not import..

Problem now is i dont know how to use Union Query...Appreciate if you could
explain further

Thanks

 

[Van T. Dinh]

Check Access Help on Union or Union Queries.

There are examples in Help also.