How to convert SQL Server database to MS Access?

Stephen West ~ Modified: March 2nd, 2016 ~ ~ 1 Minute Reading

This topic has 2 replies, 3 voices, and was last updated 8 years, 2 months ago by Stephen West.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
January 21, 2016 at 1:03 pm #1054 Score: 0

Stephen West
Moderator

Karma: 4 pts

I want to convert my MS SQL Server database to Microsoft Access. Does anyone know a way to do this so that I can use SQL Server Data in Microsoft Access.

January 22, 2016 at 1:24 pm #1062 Score: 0
Lincoln Burrows
Moderator

Karma: 16 pts
Simply follow the below steps to export SQL Server data to MS Access
- Go to the tables in MS Access database tab
- Select Import
- Make an odbc connection with SQL database
- And import tables.
February 27, 2016 at 1:13 pm #1381 Score: 0
Andrew Jackson
Moderator

Karma: 1 pt
To export SQL Server Database to MS Access
- Right click the database name in SQL Server.
- Select Tasks >> Export data
- Press Next
- From Choose a Destination screen. Use the Destination drop down to select MS Access.
Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.