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 unsu
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
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 Acces
in access >>>File Menu >>> Export 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 us
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
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
> 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:
http://www.mysql.co
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 addres
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:
>
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 th
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 c
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 wi
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 pro
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 a
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 th
15 matches
Mail list logo