By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Manipulating Excel data with ASP.NET

P: n/a
Jim
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?
Nov 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Wed, 2 Nov 2005 10:10:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

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?

So "Info" and "Index" are values in respective cells of the first row in the BallisticInfo
Worksheet?

In addition, have you specified HDR=Yes in your connection string?
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #2

P: n/a
Try

UPDATE [BallisticInfo$] SET [Info] =3200 WHERE [Index] = 1
HTH

Elton Wang

"Jim" wrote:
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?

Nov 19 '05 #3

P: n/a
Jim
I tried that parameter, and OLE DB throws this exception: Could not find
installable ISAM.

"Paul Clement" wrote:
On Wed, 2 Nov 2005 10:10:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ 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?

So "Info" and "Index" are values in respective cells of the first row in the BallisticInfo
Worksheet?

In addition, have you specified HDR=Yes in your connection string?
Paul
~~~~
Microsoft MVP (Visual Basic)

Nov 19 '05 #4

P: n/a
Jim
I just tried that, and I received this exception: 'BallisticInfo$' is not a
valid name. Make sure that it does not include invalid characters or
punctuation and that it is not too long.

"Elton W" wrote:
Try

UPDATE [BallisticInfo$] SET [Info] =3200 WHERE [Index] = 1
HTH

Elton Wang

"Jim" wrote:
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?

Nov 19 '05 #5

P: n/a
On Wed, 2 Nov 2005 12:05:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

I tried that parameter, and OLE DB throws this exception: Could not find
installable ISAM.


The syntax is a little tricky once additional arguments are added.

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #6

P: n/a
Jim
Thank you, that works

"Paul Clement" wrote:
On Wed, 2 Nov 2005 12:05:03 -0800, Jim <Ji*@discussions.microsoft.com> wrote:

¤ I tried that parameter, and OLE DB throws this exception: Could not find
¤ installable ISAM.
¤

The syntax is a little tricky once additional arguments are added.

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Paul
~~~~
Microsoft MVP (Visual Basic)

Nov 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.