Sep 19, 2005 #1 lupien1 Programmer Mar 1, 2005 34 CA With Oracle i use: COPY FROM USER/PW@ODBC:ACCESS_DB INSERT TAB1 USING SELECT * FROM TAB1; to copy the data content of the table tab1 from access to oracle tab1. What can i do to have the same result with Sqlserver. Thank you!
With Oracle i use: COPY FROM USER/PW@ODBC:ACCESS_DB INSERT TAB1 USING SELECT * FROM TAB1; to copy the data content of the table tab1 from access to oracle tab1. What can i do to have the same result with Sqlserver. Thank you!