Import Data from MSSQL

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'm very much a "newbie" on this subject.

But here goes.

I'd like to import data into Access from MSSQL.

I'm interested in the how to do this manually, and via
VBA code.

Suggestions?

Thank You
Mark
 
Do you want to import into an Access ADP? Those do not support tables.

You'll find, in some of the sponsored newsgroups on the subject of
client-server via ODBC, such as microsoft.public.access.odbcclientserver and
in the USENET newsgroup comp.databases.ms-access, discussion of DSN and
DSN-less connection to SQL Server. From an Access MDB, using Jet, and linked
tables via ODBC in the SQL Server database, you can use MakeTable queries to
copy the SQL Server data from the linked tables into tables in the Access
MDB.

Larry Linson
Microsoft Access MVP
 
Back
Top