Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Export an Access Database to SQL mdf file

Posted on 2015-02-10
6
Medium Priority
?
216 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
[X]
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
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 39

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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

610 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