MS Access to MySQL

[Bruce A. Julseth]

I need to convert an MS Access database (Single Table) to MySQL (relational
set of tables). As such, I think I'm going to have to get the data from the
MS Access table and write code to convert it to MySQL. I "think" I need an
ODBC connection to the MS Access table and tools to return a recordset. Once
I have the recordset, I can break it and store in the MySQL database tables.
That should be fairly straight forward.

So, how get at the MS Access database and return a recordset? Or, can
someone point me to tutorial?

Thank you....

[Maverick FC]

On Thu, 22 Mar 2007 22:58:20 -0400, "Bruce A. Julseth"
<br*************@bellsouth.netwrote:

I need to convert an MS Access database (Single Table) to MySQL (relational
set of tables). ...

I think http://www.heidisql.com/ can easily do that.

HTH.
Maverick

--
«Che non siete più liberi di non avere una casa con letto per dormire.
Lavorate voi - schiavi dei soldi - che non sentite la puzza della
schiavitù!» (a Mario di Monte Mario, Roma) # http://libre.netsons.org/

[Richard Formby]

Bruce A. Julseth wrote:

>I need to convert an MS Access database (Single Table) to MySQL (relational
set of tables). As such, I think I'm going to have to get the data from the
MS Access table and write code to convert it to MySQL. I "think" I need an
ODBC connection to the MS Access table and tools to return a recordset.
Once I have the recordset, I can break it and store in the MySQL database
tables. That should be fairly straight forward.

So, how get at the MS Access database and return a recordset? Or, can
someone point me to tutorial?

MS Access will export a database table to a .csv file.
--
Richard.

[Bruce A. Julseth]

"Richard Formby" <[e-mail] in message
news:IP*************@news-server.bigpond.net.au...

Bruce A. Julseth wrote:

>>I need to convert an MS Access database (Single Table) to MySQL
(relational set of tables). As such, I think I'm going to have to get the
data from the MS Access table and write code to convert it to MySQL. I
"think" I need an ODBC connection to the MS Access table and tools to
return a recordset. Once I have the recordset, I can break it and store in
the MySQL database tables. That should be fairly straight forward.

So, how get at the MS Access database and return a recordset? Or, can
someone point me to tutorial?

MS Access will export a database table to a .csv file.
--
Richard.

Yah, I thought about that. I could import the .csv in to MySQL as a single
Table (as it now), then read it and convert it to the relational database
(which is the new design). The "Minor" problem is that I need to continue to
use the MS Access database while developing the "New Design" web system.
Once the new system is working, I'd have to import a second time. No big
deal, I guess.

[Bruce A. Julseth]

"Maverick FC" <fr*********@NOSPAMlibero.itwrote in message
news:8q********************************@4ax.com...

On Thu, 22 Mar 2007 22:58:20 -0400, "Bruce A. Julseth"
<br*************@bellsouth.netwrote:

>I need to convert an MS Access database (Single Table) to MySQL
(relational
set of tables). ...

I think http://www.heidisql.com/ can easily do that.

HTH.
Maverick

--
«Che non siete più liberi di non avere una casa con letto per dormire.
Lavorate voi - schiavi dei soldi - che non sentite la puzza della
schiavitù!» (a Mario di Monte Mario, Roma) # http://libre.netsons.org/

I looked at this. I didn't seem like it would do what I wanted it to do...

Thanks for the suggest.. Appreciate the response..

[OmegaJunior]

On Fri, 23 Mar 2007 03:58:20 +0100, Bruce A. Julseth
<br*************@bellsouth.netwrote:

I need to convert an MS Access database (Single Table) to MySQL
(relational
set of tables). As such, I think I'm going to have to get the data from
the
MS Access table and write code to convert it to MySQL. I "think" I need
an
ODBC connection to the MS Access table and tools to return a recordset.
Once
I have the recordset, I can break it and store in the MySQL database
tables.
That should be fairly straight forward.

So, how get at the MS Access database and return a recordset? Or, can
someone point me to tutorial?

Thank you....

Maybe this helps:
http://www.w3schools.com/php/php_db_odbc.asp

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/