Copy and Paste a table using code..

[chickenbrew]

How do i copy and paste my link table (linked via ODBC to a cache database) in access using code rather than manually..

the standard make table query method doesnt work because a cache table ODBC errors at any attempt to make table so it has tto be the code equivilant of right click copy, left click paste structure..

thanks in advance.

 

[PHV]

You can't do this ?
SELECT * INTO newLocalTable FROM linkedTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[chickenbrew]

erm... afraid not...

that odbc errors out..

its a nightmare..