🚀 go-pugleaf

Ah, yes. It treats d: as parameter. Set ParamCheck to false. Anyway there
should be no parameters in this query. BTW, d:\\test.xls (double slash), and
quotes missed

".... IN \"\" [Excel 8.0;Database=d:\\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:4146f15a$1@newsgroups.borland.com...
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:4146b03c@newsgroups.borland.com...
> > SELECT * INTO Sheet1 FROM [Sheet1$] IN "" [Excel 8.0;Database=test.xls]
>
>
>
>
> I tried but still got OleException error !
>
> Says ParameterObject is not correctly defined
>
> What should i do?
>
>
>
> I arrange my last code as follows:
>
>
>
>  ADOCommand2->CommandText =
>
>                     "SELECT * INTO data2 IN 'd:\\zwork2.mdb' FROM
[Sheet1$]
> IN  [Excel 8.0;Database=d:\test.xls]";
>
>  ADOCommand2->Execute();
>
>
>
> Help me please
>