I've looked around, and I can't find the answer to this:
MS Access, Insight driver 6.40.00.6, in an SQL pass-through query, entering
SELECT regno INTO test FROM tmpsrch;
does nothing, although it works fine from psql. Same for CREATE TABLE AS.
User is the same in both cases, and in any case CREATE TABLE test (regno
int4) works fine as a pass-through query.
Is SELECT INTO impossible via ODBC?
Yours,
Moray