Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL->Access?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL->Access?
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
sepmir1 View Drop Down
Newbie
Newbie
Avatar

Joined: 19 April 2004
Location: Portugal
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sepmir1 Quote  Post ReplyReply Direct Link To This Post Topic: SQL->Access?
    Posted: 23 August 2004 at 5:41pm

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?

 
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2004 at 6:14pm
Try DTS then compare the tables from an access installation and the DTS version. Should be ok.
Renegade Minds - Guitar Software Slow Down Music
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post Posted: 24 August 2004 at 2:42pm
why do you want to move from SQL to Access?

I wont allow you to do it, unless you have a VERY good reason
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 24 August 2004 at 3:03pm
He might be moving to a host that does not support MSSQL, there are many reasons
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post Posted: 25 August 2004 at 11:09am
I know.. but it may also be another reason..

but if you're not forced to change database, DON'T do it..
Back to Top
sepmir1 View Drop Down
Newbie
Newbie
Avatar

Joined: 19 April 2004
Location: Portugal
Status: Offline
Points: 14 		Post Options Post Options   Thanks (0) Thanks(0)   Quote sepmir1 Quote  Post ReplyReply Direct Link To This Post Posted: 26 August 2004 at 1:43pm

Originally posted by Mart Mart wrote:

He might be moving to a host that does not support MSSQL, there are many reasons

GOTCHA!!!!

Also I don’t have too many traffic to justify an SQL server.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.