🚀 go-pugleaf

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.