🚀 go-pugleaf

$ 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.
>