🚀 go-pugleaf

Hi thanks for your reply

I managed to get it to work by rearranging the SQL statement

it now looks like this:

 SELECT * FROM CurrentWOwithLabelPN INTO
[c:\labels.mdb].CurrentWOwithLabelPN

Jonny


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3e719908$1@newsgroups.borland.com...
> 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
> >
> >
>
>