Web Wiz Support and Community Forums : Import from SQL to Access https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 23:33:07 +0000 Fri, 27 Aug 2004 14:35:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11606 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Import from SQL to Access : you can open the relationship...]]> https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64342.html#64342 Author: dj air
Subject: 11606
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.]]> Fri, 27 Aug 2004 14:35:27 +0000 https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64342.html#64342 <![CDATA[Import from SQL to Access : You are right but I will loose...]]> https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64325.html#64325 Author: sepmir1
Subject: 11606
Posted: 27 August 2004 at 4:25am

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

]]> Fri, 27 Aug 2004 04:25:00 +0000 https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64325.html#64325 <![CDATA[Import from SQL to Access : Thanks! I will feedback you about...]]> https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64307.html#64307 Author: sepmir1
Subject: 11606
Posted: 26 August 2004 at 1:48pm

Thanks!

I will feedback you about the results...

 

]]> Thu, 26 Aug 2004 13:48:28 +0000 https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64307.html#64307 <![CDATA[Import from SQL to Access : It is the exact thing as going...]]> https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64206.html#64206 Author: michael
Subject: 11606
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.

Edited by michael]]> Tue, 24 Aug 2004 09:40:45 +0000 https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64206.html#64206 <![CDATA[Import from SQL to Access : Hi guys! I have traveling...]]> https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64167.html#64167 Author: sepmir1
Subject: 11606
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?

]]> Mon, 23 Aug 2004 17:24:33 +0000 https://forums.webwiz.net/import-from-sql-to-access_topic11606_post64167.html#64167