Questions | Solutions | Experts

Select Categories Below

.net [

]

asp.net [

]

browsers [

]

C# [

]

CSS [

]

Databases [

]

email [

]

Errors [

]

HTML [

]

information tec... [

]

Question

Status: Closed Points: 100 Time: 04:32 - Feb 13, 2007

Anpanman

how to export a database from ms sql server to access?

I need to create a database in Access 2003 with the same/similar structure as a MS SQL Server 2000 database. I also need to copy the data.

I have tried to generate the sql statements in ms sql server and then running them in the query window of Access, but that didn't work since the datatypes are not equal.

So how should I do it?

Categories:

Access SQL Server
Databases sql

Answer Discussion

Answer Summaries

Q&A System for Websites and Corporate Collaboration

Generates significant organic traffic for websites
Saves companies money, resources, and time

Anpanman

Date:: Mar 23, 2007

Time:: 15:36

i found that it is possible with the enterprise manager (v. sql server 2000)
right click on the database to export, choose all tasks/export data
and then the right datasource (Microsoft Access). then you have to point to the database and that basically does it. But there are a few peculiarities. For example a bit column is not converted well, (makes 0 and -1 entries in a Yes/No column) which means the opposite of what it should.

Question Answered

This question has been closed, and points have been rewarded to the following experts:

Anpanman:

100

You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for the Summary Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No summaries have been submitted yet. Want to be the first?