Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Closed Points: 100 Time: 04:32 - Feb 13, 2007
Anpanman
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:
Add Categories
When adding more than one category, separate them with commas.
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:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial 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?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
How do I connect to an ms access database with NHibernate?
change owner of objects in ms sql server
A server with this name already exists - sql server 2000 problem
How do I restore a database on sql server through the command prompt?
sql server 2000: Generate insert scripts for data?
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software