SQLServer to Access
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3221
Printed Date: 29 March 2026 at 12:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQLServer to Access
Posted By: joshb
Subject: SQLServer to Access
Date Posted: 02 June 2003 at 9:00pm
|
I am looking for a tool to export data from a SQL Server database to a Access database. I know SQL Server has an export feature but it does not carry over default values which causes quite a bit of extra work, since I am lazy I would like to know if there is a tool that will do a better job then SQL Server's inherent tool? Thanks ------------- I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments. http://www.soopportal.com"> 
|
Replies:
Posted By: michael
Date Posted: 03 June 2003 at 8:27am
|
The problem is that default values very often are different in access. I have not found a good free tool that does it. I am using Erwin with a plugin to do it the efficient way but I don't want to know if you want to spend that much for a tool. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: joshb
Date Posted: 03 June 2003 at 8:35am
|
I was looking more along the lines of free, but how much is Erwin? ------------- I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments. http://www.soopportal.com">
|