Web Wiz Forums - Import from SQL to Access

Print Page | Close Window

Import from SQL to Access

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11606
Printed Date: 08 April 2026 at 11:30pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Import from SQL to Access

Posted By: sepmir1
Subject: Import from SQL to Access
Date Posted: 23 August 2004 at 5:24pm

Hi guys!

I have traveling all WWF to find a similar topic: SQL to Access migration!

There�s a lot of info regarding Access to SQL but not versa�.

I�ve the following problem. I have 1000 posts in my SQL server (WWF 7.7a) but I want migrate to Access (WWF 7.9).

I�m losing my mind because I don�t want lose that info.

Is there any idea how to import?

Replies:

Posted By: michael
Date Posted: 24 August 2004 at 9:40am

It is the exact thing as going to sql, just turn it around. Either use dts to export (better) or import from within access. if you import from within access it may rename your tables to dbo_tablename or something like that.
Just use an empty access forum db to export to.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: sepmir1
Date Posted: 26 August 2004 at 1:48pm

Thanks!

I will feedback you about the results...

Posted By: sepmir1
Date Posted: 27 August 2004 at 4:25am

You are right but I will loose all relations between the tables�

Posted By: dj air
Date Posted: 27 August 2004 at 2:35pm

you can open the relationship table in access and if you have a copy of the orginal access forum database,

you can then look at the relationships in the orginal and then duplicate them to the new one.