Results 1 to 2 of 2
2003-03-25, 16:21 #1
- Join Date
- Sep 2002
- Dallas, Texas, USA
- Thanked 0 Times in 0 Posts
Linking problems (Access/Excel 2002)
I am working with a linked Excel table in Access and am having trouble. I made several changes in Excel including concatenating, deleting and adding fields, and filtering copying pasting. I then went into my form in Access adn did some data entry into the form for the linked table. Then I closed both and tried to open and got External data not in expected format and my excel table is in a terrible mess. Thank goodness for GoBack. Suggestions? Not messing with fields of linked tables? Have Access closed while I am working with Excel table or vice versa?
2003-03-25, 16:30 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Linking problems (Access/Excel 2002)
If you change the structure of the Excel table, you need to delete and then recreate the linked table in Access. Deleting a linked table in Access won't delete the source data in Excel.
A linked table will not automatically update its structure, only the data. If the field structure in the original has changed, it becomes unpredictable what Access will do if you do not recreate the link. Most probably, you will have to modify the form based on the linked table too.