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]

Re: MS Access to MySQL

On Thu, 22 Mar 2007 22:58:20 -0400, "Bruce A. Julseth"
<bruceaj_nospam _@bellsouth.net wrote:

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]

Re: MS Access to MySQL

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]

Re: MS Access to MySQL


"Richard Formby" <rf@invalid.com wrote in message
news:IPHMh.645$ M.494@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]

Re: MS Access to MySQL


"Maverick FC" <freeculture@NO SPAMlibero.itwr ote in message
news:8qg60359f1 94e6uvgogqnq462 b9ke3ulom@4ax.c om...

On Thu, 22 Mar 2007 22:58:20 -0400, "Bruce A. Julseth"
<bruceaj_nospam _@bellsouth.net wrote:
>

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

Re: MS Access to MySQL

On Fri, 23 Mar 2007 03:58:20 +0100, Bruce A. Julseth
<bruceaj_nospam _@bellsouth.net 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?
>
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/