Hi Peter.
The hash indicates its a temporary tebale. if I remove the #, it will probably create a new tabel on the Database, whcih I dotn want it to do.

I have used similar command with the Sql driver and there is no problem, so maybe the Oledb driver does not support creation of Temporary tables ??

Regards,
Gerard


>Just a wild guess - try removing the # from #MyTable