G
Guest
I have a Web application that needs to update a Microsoft Excel spreadsheet
for complex calculations, whereby I read the results into a dataset for
display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
use and SQL update statement to update a cell in my spreadsheet, but I keep
receiving the error: No value given for one or more required parameters.
From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
= 1
BallisticInfo is the name of the spreadsheet and Info and Index or column
names. Any ideas?
for complex calculations, whereby I read the results into a dataset for
display. I am accessing my spreadsheet using OLE DB and ADO. I'm trying to
use and SQL update statement to update a cell in my spreadsheet, but I keep
receiving the error: No value given for one or more required parameters.
From this SQL statement: UPDATE BallisticInfo SET [Info] =3200 WHERE [Index]
= 1
BallisticInfo is the name of the spreadsheet and Info and Index or column
names. Any ideas?