< Browse > Home / tech / Blog article: SQL Server vs Access

| Mobile | RSS

SQL Server vs Access

June 14th, 2009 | 1 Comment | Posted in tech

How to import data from SQL Server 2005 to Microsoft Access throw VBA code? Quite simple. The problem is finding the correct SQL connection string:

DoCmd.TransferDatabase acImport, “ODBC”, _
“ODBC;DRIVER=SQL Server;” & _
“UID=username;” & _
“DATABASE=databasename;” & _
“SERVER=server;” & _
“PWD=password“, acTable, “table1“, “table1_copy“, False, True

I lost so many hours figuring out what the hell did “Could not find installable ISAM” means…

Bookmark and Share
Leave a Reply 311 views, 5 so far today |
  • No Related Post
Follow Discussion

One Response to “SQL Server vs Access”

  1. forexstrat_egy Says:

    I am definitely bookmarking this page and sharing it with my friends.

    :)

Leave a Reply


DSC01119Assembly_February_2010_119252.Portugal-por-Matthew-Gohl2DSC_0243FILE1169DSCF6297IMG_0026IMG_0703