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
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:
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
