🚀 go-pugleaf

First of all thank you on your answer and sorry for my late response,
I'm using ADOConnection and ADOQuery, so I've tried to enter code you've
posted to SQL of ADOQuery, but I can't seem to make connection to excel 
file.

using your code:

 > INSERT INTO MyTable(Col1, Col2)
 > SELECT Col1, Col2
 > FROM [Sheet1$] IN ""[Excel 8.0;Database=c:\myxls.xls]

and changing ADOQuery1->Active = false to ADOQuery1->Active = true

I get error: "Parameter object is improperly defined. Inconsistent or 
incomplete information was provided."

First I thought quotation marks were misplaced, but I've tried every 
possible position without success.


I get the syntax, but don't know what to define in from clause, do I 
need to add something else like :
FROM [Sheet1$] IN ['Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;']

Thanks in advance,
Tomislav.


Vassiliev V. V. wrote:
> Connect to Access database and execute:
> 
> INSERT INTO MyTable(Col1, Col2)
> SELECT Col1, Col2
> FROM [Sheet1$] IN ""[Excel 8.0;Database=c:\myxls.xls]
> 
> [Sheet1] - named diapason, [Sheet1$] - sheet (if it does not work, try 
> [$Sheet1]), [Sheet1$B5:C10] - cells range.
> 
> //------------------------------------------
> 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)
> 
> 
> "Tomislav Hundric'" <rifnet@gmail.com> �������/�������� � �������� 
> ���������: news:46dae1d4$1@newsgroups.borland.com...
>> Please help,
>> I need to populate database table from excel file. My database table has 
>> same fields as excel file has columns. I use ADO connection to connect to 
>> database. Can anyone give me some guide lines or example how to do this.
>>
>> Thanks in advance. 
> 
>