Home » Topic » How to convert SQL Server database to MS Access?

How to convert SQL Server database to MS Access?

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

Home › Forums › How to convert SQL Server database to MS Access?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • January 21, 2016 at 1:03 pm #1054 Score: 0
    Stephen West
    Moderator
    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
    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
    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.