[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Export an Access Database to SQL mdf file

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
chaverly
Asked:
chaverly
1 Solution
 
hnasrCommented:
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
 
PatHartmanCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Nick67Commented:
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
 
chaverlyAuthor Commented:
Thank you
0
 
hnasrCommented:
Welcome!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now