🚀 go-pugleaf

SELECT * INTO Sheet1 FROM [Sheet1$] IN "" [Excel 8.0;Database=test.xls]

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

"uchan" <usami_takeshi@yahoo.co.jp> $B'c'`'`'R'k'Z'](B/$B'c'`'`'R'k'Z']'Q(B $B'S(B
$B'_'`'S'`'c'd'q'g(B $B'c']'V'U'e'p'k'V'V(B: news:41465b3c@newsgroups.borland.com...
> Hi  I have troubles in   Copying  Excel Sheet to Accesss mdb as Table.
>
> I wrote as follows.
>
> ADOQuery2->SQL=Add("insert into access_table select * from
> [D:\exceldata.xls.sheet1];");
> ADOQuery2->ExecSQL();
>
> when it was excuted OleException erro occurs(it didn't works.)
>
> Thanks
>
> Using BCB6 Pro
> ---------------------------
> uchan
> $B!w(BOKAZAKI JAPAN
>
> --------------------------- 
>