Import Data from MSSQL

[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

 

[Larry Linson]

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

 

[Lyle Fairfield]

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

There is a procedure outlined in

http://groups.google.ca/[email protected]

which may do what you want.