🚀 go-pugleaf

Use connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\Test.xls;Extended
properties=Excel 8.0

Query is:

From sheet:
Select * from [Sheet1$]

in some cases $ - after name, in other - before, i.e. $Sheet1

From named diapason:
Select * from [DiapasonName]

From range:
Select * from [Sheet1$B5:C10]

//------------------------------------------
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)

"FlyR" <john.wild@msa.hinet.net> �������/�������� � �������� ���������:
news:416b493e@newsgroups.borland.com...
> my ADOQuery Control set as follow.
>
>   object Query: TADOQuery
>     ConnectionString =
>       'Provider=MSDASQL.1;Persist Security Info=False;Data Source=Data
>     Parameters = <>
>     Left = 48
>     Top = 40
>   end
>
>
>
>
> void __fastcall TForm1::Button1Click(TObject *Sender)
> {
> AnsiString SqlStr;
>
> SqlStr="Select * from ImageDataBase";
> Query->SQL->Clear();
> Query->SQL->Add(SqlStr);
> Query->Open();
>
> Query->Append();
> Query->FieldValues[0] ="test";
> Query->Post();
> }
>
> then I add a ODBC data source for Excel file. The Data Soruce name is
> "Data".
>
>
> I Excute this program. It has something wrong. But I cant solve it. Please
> help me.
> Thanx.
>
>