Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Export an Access Database to SQL mdf file

Posted on 2015-02-10
6
Medium Priority
?
233 Views
Last Modified: 2016-02-11
I want to export an Access database that I created to a SQL database with an mdf extension. How do I do that in Access 2010? Eventually, I want to use it in Microsoft SQL 2008 R2 Express for queries.
0
Comment
Question by:chaverly
6 Comments
 
LVL 31

Accepted Solution

by:
hnasr earned 2000 total points
ID: 40601716
For a small database:

Create a new SQL database.
In access, select table/Query in navigation pane > External Data > Export > More > ODBC Database

Follow instructions.
0
 
LVL 40

Expert Comment

by:PatHartman
ID: 40602459
With A2010 and earlier, you can use the built in upsizing wizard.  It is on the External data ribbon.  This feature was dropped from A2013 and that leaves you with SSMA as recommended by SStory or a third party tool unless you want to do the tables one at a time as hnasr recommended.
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
LVL 26

Expert Comment

by:Nick67
ID: 40603591
it could be coded in VBA, but that is a lot of work to go to when the very good, free SSMA tool exists.
Be aware that SSMA comes in 32 bit and 64 bit flavours.
Both run on x86 and x64 platforms.
The correct one to use depends on the version of the connectivity components you have installed.
If you have 32 bit ODBC drivers, you need the 32 bit version
If you have 64 bit ODBC drivers, you need the 64 bit version.
Both install from the download.
Try the 32 bit first if you do not know for certain (it's highly unlikely) that you have installed 64 bit Office.
0
 

Author Closing Comment

by:chaverly
ID: 40613312
Thank you
0
 
LVL 31

Expert Comment

by:hnasr
ID: 40613340
Welcome!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question