Import Data from MSSQL


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
 
Ad

Advertisements

L

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top