🚀 go-pugleaf

Inside C++: ... Database=c:\\myxls ... . I.e. do you escape '\' character in 
path? Are you sure that enumeration starts from 0, not from 1, i.e. do you 
have file c:\myxls0.xls?

> ADOQuer1->SQL->Add(...)

Do you clear ADOQuery1->SQL before calling Add()?

//------------------------------------------
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:46ebc074$1@newsgroups.borland.com...
> I'm sorry for asking before looking into help, I've managed to do it via 
> ADOCommand, but now I've got other question regarding my previous post 
> about inserting excel file into Table.
>
> Since I'm using:
>
> INSERT INTO MyTable(Col1, Col2)
> SELECT Col1, Col2
> FROM [Sheet1$] IN ""[Excel 8.0;Database=c:\myxls.xls]
>
> and that works fine when I enter it into SQL property of ADOQuery, but 
> I'll be inserting lets say 10 or more excel files into table, I'm thinking 
> of using loop that will add
>
> ...""[Excel 8.0;Database=c:\myxls1.xls]
> ...""[Excel 8.0;Database=c:\myxls2.xls]
> ...""[Excel 8.0;Database=c:\myxls3.xls]
> ...
>
> since there are two quatation marks in front of the brackets, I don't know 
> how to apply them to my string correctly.
>
> String SQL = "INSERT INTO MyTable(Col1, Col2)SELECT Col1, Col2 FROM 
> [Sheet1$] IN \"\"";
>
> for (int i= 0; i < someNumber; i++){
> ADOCommand1->CommandText= SQL + "[Excel 8.0;Database=c:\myxls" + 
> IntToStr(i) +".xls]";
> ADOCommand1->Execute();
> }
>
> or
>
> for (int i= 0; i < someNumber; i++){
> ADOQuer1->SQL->Add(SQL + "[Excel 8.0;Database=c:\myxls" + IntToStr(i) 
> +".xls]";
> ADOQuery1->ExecSQL();
> }
>
>
> Both of them throw me an exception "Microsoft Jet database engine could 
> not find object Sheet1..." is there some other way to solve this.
>
> Again, thanks in advance,
> Tomislav.
>
> Tomislav Hundric' wrote:
>> Hi,
>> I've got a question regarding insert into table, I'm using access 
>> database, ADOConnection and ADOQuery:
>>
>>
>> I have SQL like this:
>>
>> Insert into Table1 (Field1)
>> Select distinct Field2
>>  From Table2
>>
>> Executing this query throws me this error
>>
>> "current provider does not not support returning multiple recordsets from 
>> simple execution"
>>
>> When I look into my table I can see that records are added even though an 
>> error was thrown. Basically what I'm trying to do is to fill relational 
>> tables with data from one temp table. Is my approach ok, or should I do 
>> this in some other way.
>>
>> Thanks in advance,
>> Tomislav.