use oracle's wizard. "David Green" <[EMAIL PROTECTED]> wrote: First of am New to CF. But I had to go to Access to SQL 6.5 and did not have the upsizing wizard. What I did was create database in on the SQL server then created an ODBC connection to the database. I then openned the DB in access and the exported it to the ODBC database which was an option in access under file types in the export area. This created the schema and move the data over for me. I have not tried to move a view and did not check the indexes I just recreated those. I don't know if this works with oracle but did work with SQL server. Well hope that helps. If well am a Newbie and I tried :) David Green ----- Original Message ----- From: "Richard Colman" <[EMAIL PROTECTED]> To: "Cf-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 2:44 PM Subject: ACESS to Oracle > Is there some easy, automated method for copying/converting an ACCESS > database to an Oracle database. One can always do it the hard way (recreate > the schema, output as a delimited text file, load it back into oracle, etc. > etc.) but ... > > TNX. > > -------------------------------------------------------------------------- ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
