RE: Update Excel Work***

Hello Brassica,

1. To start querying from the ninth row, we have two options.

A. Explicitly specify the range we need in the command string.
e.g.
Select * from [Sheet1$A1:B10]
Where Sheet1 is the name of the sheet, and A1:B10 is used to specify the
range the command will operate on.

B. Define a name for the range in Excel (e.g. MyNamedRange), then use the
name in our command string
e.g.
Select * from [MyNamedRange]

About how to define a named range in Excel:
Step1. Open the workbook in Excel
Step2. Select the range we need to define the name
Step3. On the top-left corner of Excel, there is a textbox. Type the name
(e.g. MyNamedRange) there and press enter.

2. About the error "No value given for one or more required parameters" in
Update command
The provider thinks there is a parameter without value in your SQL command.
It's very likely to be caused by the use of '?'.
See: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=181862&SiteID=1
Or would you paste your Update command string here, and I will check it for
you.

3. The best document for using Microsoft Jet Database engine 4.0 to
read/write Excel.
I think my best-loved one is the KB article:
http://support.microsoft.com/kb/316934/en-us
This article is a complete walkthrough of the topic with easy-to-follow
sample codes. It also explains some common error-codes thrown by the
engine, which facilitates our trouble-shooting work.

If you have any other concerns or questions, feel free to let me know.

Regards,
Jialiang Ge (jialge@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

.