Hi
This is what I would like to do:
I've got a program with a SQL-table with articles and one with recipes.
I want to use this data in Excel. Therefore I use a MS Query.
Since I'm missing some attributes for both the articles and recipes inside the program
I want to add some extra columns inside the worksheet.
My problem:
how can Excel remember the relation between the values in those extra columns and the external data.
Once new articles and recipes have been added inside SQL
and I refresh the query, the data in the extra columns is mixed up, since the new data is not added in new rows under the existing ones.
Example:
(ED= external data in SQL) (ID = internal data / manualy added columns in Excel worksheet)
before update
EDarticlenumber1234 EDarticledescription1234 IDadditive1234
EDarticlenumber1265 EDarticledescription1265 IDadditive1265
EDarticlenumber1378 EDarticledescription1378 IDadditive1378
after update, article 1262 has been added to SQL
EDarticlenumber1234 EDarticledescription1234 IDadditive1234
EDarticlenumber1262 EDarticledescription1262 IDadditive1265
EDarticlenumber1265 EDarticledescription1265
EDarticlenumber1378 EDarticledescription1378 IDadditive1378
Any help is appreciated.
Bookmarks