P
poneken
How can I make a calculated field value generated when
programmatically update the depending cell by using a 'update
statement through 'Microsoft Jet 4.0 OLE DB Provider'?
If this is not clear, here the situation:
--------------------------------------------------------------------------------------------------
I have an Excel file, which has bunch of calculated cells on one shee
and their values are based on a selected cell ( in this case produc
code ) from a drop down list on another sheet. User can select
product to see all the associated derived values on another sheet.
Now I want to put all these information for all products int
SQL-Server database. and what I am thinking to accomplish this is:
write a SQL script that will loop through all the product codes in th
dropdown list and retrieve all generated values per product int
SQL-Server.
The script I wrote was able to loop through the product code list, an
update the selected field as if it was chosen interactively. However
the calculated cells are not populated even though the value o
selected cell is changed. However, when I interactively open up th
Excel file, the calculated cells are populated per the last selecte
product.
programmatically update the depending cell by using a 'update
statement through 'Microsoft Jet 4.0 OLE DB Provider'?
If this is not clear, here the situation:
--------------------------------------------------------------------------------------------------
I have an Excel file, which has bunch of calculated cells on one shee
and their values are based on a selected cell ( in this case produc
code ) from a drop down list on another sheet. User can select
product to see all the associated derived values on another sheet.
Now I want to put all these information for all products int
SQL-Server database. and what I am thinking to accomplish this is:
write a SQL script that will loop through all the product codes in th
dropdown list and retrieve all generated values per product int
SQL-Server.
The script I wrote was able to loop through the product code list, an
update the selected field as if it was chosen interactively. However
the calculated cells are not populated even though the value o
selected cell is changed. However, when I interactively open up th
Excel file, the calculated cells are populated per the last selecte
product.