March 11, 2010 at 5:01 am
Hi people.
I have a problem between Access and Sql2005.
I use a linked table inside temporary access mdb.
Client have sqlexpress insalled (two version : one is 9.0.053 and the other 9.0.035)
With sql2005 with 9.0.035 everithing work good.
With sql2005 with 9.0.053 a "ODBC - Call failed " appear when i try to executa an "INSERT INTO SQLXXX FROM SELECT * FROM ACCESSXXX"
someone can help me ????????
March 11, 2010 at 7:37 am
Alberto.Omini (3/11/2010)
Hi people.I have a problem between Access and Sql2005.
I use a linked table inside temporary access mdb.
Client have sqlexpress insalled (two version : one is 9.0.053 and the other 9.0.035)
With sql2005 with 9.0.035 everithing work good.
With sql2005 with 9.0.053 a "ODBC - Call failed " appear when i try to executa an "INSERT INTO SQLXXX FROM SELECT * FROM ACCESSXXX"
someone can help me ????????
It looks like the syntax is wrong. I would think it should be:
INSERT INTO SQLXXX (col1,col2)
SELECT othercol1, othercol2
FROM ACCESSXXX
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply