linked table

[tizwaz]

am I right in thinking that if I link to an existing excel spreadsheet that I can't create a primary key and add the table to the relationships window? (it's letting me add the table but there are no fields in it)
If so how can I link it to other tables?

 

[tizwaz]

sorry ignore much of what I just posted. I can add the table to the relationship window.
The only problem I have is I can't create a primary key. Is this how its supposed to be - if so will it cause any problems?

 

[dhookom]

Since you can't create a primary key in Excel, I don't think you can create one in Access on a linked Excel spreadsheet.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[JeremyNYC]

It will cause problems if you're expecting it to act like it has a primary key. You just have to plan for what you have. Can you just move the data from excel to Access?

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[tizwaz]

Not really - in the spreadsheet the fields are being constantly updated using quite a complicated formula and its quite a big sheet. Only other alternative is to keep copying it over. Thanks anyway

 

[koresnordic]

How about the transfer spreadsheet option? Is the data changing all the time? If so, then this probably will not help. If not, then use the transfer spreadsheet option to move to an internal table, and have this table with the required key field. A query will be required to empty the existing table before using the transfer option. Or after deleting the existing data from the table, have an append query to add the data from the original linked table into the internal table.



Graham