Hi all, does anyone use this program MySQL Front 2.8 to convert access to
mysql? I have been looking in the menus and cant see anything to do it. Any
other programes that do the job?
Thanks a lot for any advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
SELECT @myvar := 1 ;
-Original Message-
From: Gerald Norman [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 01, 2002 10:37 PM
To: [EMAIL PROTECTED]
Subject: Converting Access to MySQL
I have an application that currently is using an Access
database and am
in the process
I have an application that currently is using an Access database and am
in the process of converting over to MySQL. I downloaded the ODBC
driver and have been using ADO and have had no problems at all up to
this point. I have a number of parameterized SQL statements that
worked fine in
HHG You must go to control panel of windows in Data Sources(ODBC) section and add
your DSN of you new MySQL database and then you can explor the database by browsing
your ODBC avilable databases .
HHG You can check MyODBC manual for this .
Yes, this worked for me too.
However ... I can only
L Ok i'm still a little bit lost. I have a database in MySQL called "irm"
L In the ODBC Data Source 32 bit I went in user dsn and added user data source
L called irm the driver is mysql
L not this is were i dont understand .
L In the field that says Windwos DSN name I put "irm"
L MySQL I put
in access File MenuExport or Import, depending which
way youre goin' Follow on screen inst.
scott
At 03:06 PM 4/3/01, you wrote:
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
-
Before posting, please
Luis wrote:
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to the ODBC
Hi ,
You must go to control panel of windows in Data Sources(ODBC) section and add your DSN
of you new MySQL database and then you can explor the database by browsing your ODBC
avilable databases . You can check MyODBC manual for this .
On Tue, Apr 03, 2001 at 06:55:52AM -1000, Luis wrote:
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data source
called irm the driver is mysql
not this is were i dont understand .
In the field that says Windwos DSN name I put "irm"
MySQL I put the ip
In the field were "Windows DSN name" what do I put there.
Also if i just created a database in mysql called customer
would i put the that name in "MySQL database Name"
-
Before posting, please check:
Hello to all, I was wondering if anyone could help me out with a little project i
have going. I have a database in access 7.0 I would like to transfor all the
fields, tables, plus information it has to mysql running on a linux box (rh 7.0)
running mysql.
now how would i go about that?
is there
Luis,
This is an easy one.
Go here ftp://ftp.informate.co.nz/pub/ and download one of the scripts, the
instructions are in the script. It will create a text file that has the sql
commands needed to create and fill your mySQL tables with your Access info.
You can exec the script from the mySQL
Thank you for the help, but I'm a newbie on MySQL . Some of the stuff i been
reading tells me to download MyODBC or i could make a txt file out of access
when exporting.
If i try to inport a all the fields from access to mysql do i have to create a
database plus tables that are the same as in
Hello all.
I was wondering if anyone could help me out with a little project I have to do.
I have a win98 machine with a access database.
I would like to transfer everything into mysql on a red hat 7 linux box.
How would I do this?
Plus how would I be able to connect once it transfer to mysql
15 matches
Mail list logo