moving data between msaccess and sql server.

what is the most efficient way to transfer data (several thousand rows) from an msaccess database to a cloud based sql server 2012 server?  should I export to file, send, and then bulk import, or is there a better way to accomplish this?
dhenderson12Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ajuer SoodConnect With a Mentor Commented:
If it is one time import then take the backup and restore it in sql using import export functionality.

If you want to connect MSACCESS to SQL you will have to look into upsizing the access DB.

In access go to >external data> odbc database> link the database.

This would create the link table in access which would allow you to use access and sql simultaneously.
0
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Do you have the rights to insert rows into the SQL Server table?  If yes, open Access, do a linked table to your SQL Server table, then just run an insert query from the access table into the SQL Server table.
0
 
dhenderson12Author Commented:
thanks, guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.