Transfering table to SQL Server

[lars7]

Hi Guy's,
I'm trying to send a table to my server with this SQL code but i get an error message "Expected:=" can anyone see where i have went wrong?

Function ODBCConnect()
Dim strSQl As String

strSQl = "SELECT * INTO [C:\Documents and Settings\Tom\Desktop].[tbltemp] " & _
"[ODBC;DSN=EmpDetSQL;UID=trusted_connection=YES;Table=dbo.tblTemp] " & _
"[ODBC;Driver=SQL Server;Server=172.31.112.32;Database=EmpDetSQL;UID=trusted_connection=YES;Table=dbo.tblTemp] " & _
"FROM tblTemp "

DoCmd.RunSQL strSQl

End Function

thanks in advance

 

[dhookom]

Get rid of [tt][red]UID=[/red][/tt].

Duane
Hook'D on Access
MS Access MVP

 

[lars7]

Hi duane,

I'm at home trying this now but I got the same error when i removed UID=

strSQl = "SELECT * INTO [C:\Users\Tom\Desktop\EmpDetSQL].[tbltemp] " & _
"[ODBC;DSN=EmpDetSQL;trusted_connection=YES;Table=dbo.tblTemp] " & _
"[ODBC;Driver=SQL Server;Server=TOM-LT\SQLEXPRESS;APP=2007 Microsoft Office System;Database=EmpDetSQL;trusted_connection=YES;Table=dbo.tblTemp] " & _
"FROM tblTemp "


and I added my home server and operating system the the 3rd line.

 

[dhookom]

I'm not sure why your SQL statement describes three datasources.

Duane
Hook'D on Access
MS Access MVP