Linked Table query

[arn0ldas]

Hello I have linked table in MS Access (table from excel sheet)
I want add some information for each line of linked table in access

Sample

Linked table:
1. First name
2. Last name
3. DATE
4. Sale order

In MS Access I want add column for this linked table
5. ZIP
6. Country
7. Reference number

can I doo like this? I can create some table or query and ADD for each line this information?

[ranman256]

you usu cant ADD to excel sheets unless you've set up for it. The default xl link does not. But you can change it.
you cant add columns to linked tables. They must be added in the XL sheet, then relinked.