Upgrade from Access to SQL

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 15 December 2004 at 11:20am
	select import and select the other tables details to the import details i think you can send just content not structure. IE make the tables details for mochasuite the import tables into the dbo ones.

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 15 December 2004 at 11:37am
	I really am lost here. I don't see a way just to import the data into the tables that are already owned by "dbo." Is there a way to login as the "dbo" instead of the "mochasuite," that way the files "might" override the existing "dbo" tables? What are the steps in just uploading the data into the "dbo" structure?
	Man Know Thyself

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 15 December 2004 at 12:18pm
	I am also going step by step of the process of the "Access to SQL Server - Step by Step" thread, and when it is doing its conversion, on all of the "Drop Table" steps, it is throwing an error. Any possible reasons? I deleted all of the tables again I ran the setup first this time Now I am importing the tables throwing error message on drop steps
	Man Know Thyself

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.