HowTo: Export tables from Access to SQL Srv

  • In Access right-click the source table – “Export…” – “SaveAs” – choose “ODBC” in the bottom of the list – choose default table name – “OK”
  • If DSN doesn’t exist create a new “Machine Data Source” (System) – choose driver “SQL server” in the bottom of the list – “Next” – “Finish” – Choose a name for the connection and choose a SQL server – “Next” – “Next” – Change default DB to the target one – “Next” – “Test Connecttion”
  • “OK”
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: