DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

MS Access make table query (1619 previews)
MS Access make table query	Posted in 27th, 09/2005 05:49 by schaef60
Here is what I'd like to do: I have an Oracle ODBC connection to a database. I'd like to use MS Access to run a make table query, and store the results in MySQL. The data is ~4Gb so it needs to go directly from Oracle thru Access to MySQL. I cannot temporarily store it in an Access file or it will exceed the 2Gb file limit. Is there a way to do this in DBTools? So far, I have been able to use MySQL ODBC connection and link to my SQL DB as a linked table in Access. That allows me to "append" or "update" in MS Access. But I cannot get it to do a make table because the MS Access menu does not have an SQL format from the pick list. Any suggestions? erik /
Re: MS Access make table query	Posted in 28th, 09/2005 09:37 by support
Hi, The Enterprise Edition can migrate directly from Oracle to MySQL using the migration Wizard. Optionally you may try dumping the Oracle table into CSV format and loading it into MySQL. THis is by far the best way to accomplish what you need. Best Regards, Support / DBTools Software
MS Access make table query (1619 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General