Import sql database into access 2010

Hi

I have an SQL database which I want to import into Access 2010.

Can anybody tell me the steps I need to accomplish this?

Thanks in advance

Issac
IssacJonesAsked:
Who is Participating?
 
als315Commented:
What is your SQL version? I will show wizard for SQL 2008. At first you should create empty Access mdb (it will be selected in step 3). Then start Wizard:
12select source server and database
3select created DB as destination
4select tables for export
5You will see possible conversion errors due to different fields types. You can correct mappings in previous step with button Edit mapppings.
6On next step press finish and be happy if there will be no erors
0
 
als315Commented:
You can use SQL server Import and Export Wizard:
http://msdn.microsoft.com/en-us/library/ms141209.aspx
or you can link all tables to Access and import them
0
 
IssacJonesAuthor Commented:
Hi als315

Can you give a step by step list of how to use the SQL server Export Wizard?

Issac
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
clarkscottCommented:
You could create the table in access (structure), link to the SQL table, and then make an "append" query to get the data from SQL to Access.   Of course, some issues:  SQL "incremented" primary key cannot be populated to an Access Primary key (autonumber).  Also, if you have any other tables with relationships to the parent table that uses the parents SQL "incremented" key...(now using the Access autonumber key) you're going to have some code to write.

Scott C
0
 
IssacJonesAuthor Commented:
als315 - I'm using SQL 2008.

In the choose destination section, when I specify the access database file I want to create e.g. sql.mdb, I get an error message saying the file doesn't exist.

Have I misunderstood?

Issac
0
 
als315Commented:
You should create empty DB in Access before starting export process (and it was in the first sentence of my comment).
0
 
IssacJonesAuthor Commented:
Hi als315 - sorry, I missed that step - D'OH! Many thanks
0
 
IssacJonesAuthor Commented:
Ah, unfortunately, I've run into a problem.

The blank database I've created will have to extension accdb. SQL Server expects an extension of mdb as far as I can see.

Have I done something wrong?
0
 
als315Commented:
You should create database in Access 2003 format (mdb). Later you can convert it to accdb.Use "Save and Publish" from File menu:
mdb
0
 
IssacJonesAuthor Commented:
als315 - Cheers m8!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.