🚀 go-pugleaf

Check that c:\labels.mdb exists, table CurrentWOwithLabelIPN exists in
database you are connected to and that you escape "\" in your code, inside
your code command should look:

SELECT * INTO CurrentWOwithLabelPN IN 'c:\\labels.mdb' FROM
CurrentWOwithLabelPN

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Jonny" <jonny@nospam.jonnywilk.co.uk> �������/�������� � ��������
���������: news:3e70c170@newsgroups.borland.com...
> Hi, I need to copy some data from one ADO connection table to another.
>
> In access I could wite an SQL statement like this:
>
> SELECT * INTO CurrentWOwithLabelPN IN 'c:\labels.mdb' FROM
> CurrentWOwithLabelPN;
>
> But If i try this on an ADO connection it just hangs
>
> I've also tried using the Clone on a dataset, but this doesn't seem to
work
> correctly either.  Also i have tried setting a tables recordset to another
> one, but this seems to mess up too
>
> Any help would be GREATLY appreciated
>
> Thanks
>
> Jonny
>
>