🚀 go-pugleaf

Vassiliev,

thanks for the help.

I removed all the extra parameters that were inserted by the build
connection string wizard to the miminum ones you have here and used 

Select * from [Sheet1$] (not [$Sheet1] as you had it) and all is well.

Thanks again for the input.

Peter Nunn.

On Mon, 14 Jun 2004 17:03:17 +0400, "Viatcheslav V. Vassiliev"
<support@oledbdirect.com> wrote:

>$ is special sign, use:
>
>From sheet:
>
>Select * from [$Sheet1]
>
>From named diapason:
>
>Select * from [DiapasonName]
>
>From range:
>
>Select * from [Sheet1$B5:C10]
>
>Use also Jet provider. Connection string is:
>
>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.xls;Extended
>properties=Excel 8.0;
>
>//------------------------------------------
>Regards,
>Vassiliev V. V.
>http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
>ADO.Net
>http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>MS Jet (Access) and Interbase (through OLEDB)
>
>"Peter Nunn" <pnunn@infoteq.com.au> ???????/???????? ? ???????? ?????????:
>news:bo3rc0defgrbhs3covm9ld7sv9r9s3ke9i@4ax.com...
>> Hi folks,
>>
>> I'm struggling with an app in which I need to update a database with
>> data stored in an Excel spreadsheet.
>>
>> I've done a bit of hunting around on the net and it seems that some
>> sort of ODBC connection would be the best way to do this (easier than
>> parsing the spread sheet line by line) but I can't seem to get it to
>> work for me.
>>
>> I've setup a system DSN for the spreadsheet (although it would be nice
>> not to have to do this), pointed a TADOConnection compenonent to that
>> and set active true (so far so good).
>>
>> When I add a TADOTable however and connect that to the ADOConnection I
>> don't see any of the workbooks in the table list.
>>
>> I tried adding Sheet1$ to the table name (from the net) but when I set
>> active here I get an error
>>
>> Syntax error in from clause.
>>
>> Any ideas what I should be doing please?
>>
>> ta.
>> Peter.
>>
>