CODEWITHSUNDEEP
sql-serverms-accessmigration
Txentxo Txentxako
Txentxo Txentxako

Reputation: 135

Migrate a .mdb app to Sql Server

I have a database in access and it haves "embeeded" code making the database works as a visual basic program via macros and vb programming. But its not a Visual Basic application its like just code, forms, macros added to the access database.

The file format is .mdb or .mde

My question is:

Its possible to split the "application" and tables? Migrate that database to a SQL Server database and attach the "application" to the new database?

Upvotes: 0

Views: 313

Answers (2)

Gord Thompson
Gord Thompson

Reputation: 123559

It sounds like you want to do exactly what the "SQL Server Migration Assistant" utility does. For more information, see

SQL Server Migration Assistant for Access (AccessToSQL)

Upvotes: 0

chris_techno25
chris_techno25

Reputation: 2477

Yes, it is possible to migrate a .mdb file into SQL Server.

1) Just create a new database on SQL Server.

2) Right click the name of the database.

3) Click on tasks.

4) Click on Import Data...

5) Then browse to your .mdb file. There are instructions as you go along.

Upvotes: 1

Related Questions