Import Data from SQL Server to MS Access Table

[akashbest@gmail.com]

I am trying to import data from a SQL Server Table to MS Access Table. Could any help me on can I get it done?


I am using ADODB Connection and Select Into (from SQL Server to MS Access DB) query to perform this task. The VBA Code is written in MS Access Database.


[SELECT *

INTO new_table_name [IN externaldatabase]

FROM old_tablename]

 

[Hui]

Have you tried an SQL or MS Access Blog ?

 

[dan_l]

Try a pass through query.


Fair warning: limit your first heavily. Pre-07 versions of access have been known to explode

 

[akashbest@gmail.com]

I was looking for a working syntax: Below is what I found and seems to be working well.


SELECT * FROM [ODBC;Driver=SQL Server Native Client 10.0;SERVER=Your_Server_Name;DATABASE=DB_Name;UID=User_Login;PWD=Your_Password]