Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Export an Access Database to SQL mdf file

Posted on 2015-02-10
6
157 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 25

Expert Comment

by:SStory
ID: 40601603
0
 
LVL 30

Accepted Solution

by:
hnasr earned 500 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 35

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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 30

Expert Comment

by:hnasr
ID: 40613340
Welcome!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 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