Question Transfer data from Access to MySQL

[mcdhappy80]

If I populate access database with some data, what would be the best and easiest way to transfer that data to MySQL database?
Is there some software or automated way, or I need to do some web programming to create this myself?
Thank You.

 

[HiTechCoach]

without a lot more details it will be difficult to give you an answer.

I could be a matter of linking tables and running append queries.

Why not enter the data directly in mySQL using Access as a front end?

 

[mcdhappy80]

without a lot more details it will be difficult to give you an answer.

I could be a matter of linking tables and running append queries.

Why not enter the data directly in mySQL using Access as a front end?

Thanks, You gave me the answer. I forgot access has append query, because I've never used it

Yes, I could link to MySQL database and use access as front end.
Could someone give me some tool I could manipulate the MySQL database (create tables without typing SQL code).

Thank You

 

[HiTechCoach]

Thanks, You gave me the answer. I forgot access has append query, because I've never used it

Yes, I could link to MySQL database and use access as front end.
Could someone give me some tool I could manipulate the MySQL database (create tables without typing SQL code).

Thank You

Have you looked ay mySQL's site. There you will find what you need.

Could someone give me some tool ..

Not all of the best tools are free.

 

[Steve R.]

First go to the subforum PHP & MySQL

There are some samples in the subform. One of samples that I modified for my use is here.

You will also need this Connector-ODBC 5.1.6

MySQL Forums :: Microsoft Access

It's going to take a bit of investigating.

 

[mcdhappy80]

Thanks guys, will search there

One last thing I wanted to ask here to hear Your opinion:
If I use Access as MySQL front end, and the database is hosted to online web host, can I connect and how to that database (through internet), and will the performance suffer?

Thank You

 

[Steve R.]

Thanks guys, will search there

One last thing I wanted to ask here to hear Your opinion:
If I use Access as MySQL front end, and the database is hosted to online web host, can I connect and how to that database (through internet), and will the performance suffer?

Thank You

That is beyond my pay-grade. I would suggest posting in that subforum.

 

[Banana]

Sure. I don't see why you can't. I've not used hosted MySQL, but I have built an Access application that contacted a remote MySQL server located at the main office.

 

[HiTechCoach]

If I use Access as MySQL front end, and the database is hosted to online web host, can I connect and how to that database (through internet), ...

Yes you can connect to a remote mySQL data over the internet. That is provided that the web server is configure to allow remote access to the database.

... and will the performance suffer?

Compared to what other option/configuration?

Are you comparing a 1000 meg (1 gig) LAN network to a 2 meg WAN/internet connection?

 

[Simon_MT]

This is a site using ASP.Net although it was migrated [mostly manually] from ASP Classic using Access databases. The initial version was Access 97, now Access 2003 format.

http://www.trevorsutton.com/

Simon

 

[Iskandar Alamsjah]

I have MySql Tables (one of the table containing Data Type "MediumBlob"). But when I read the data (by Linking) through MSAccess (2003 version), why the data containing the Mediumblob type can not view ?. Could somebody help me why ? What am I supposed to do ?. Thank you.

 

[HiTechCoach]

I have MySql Tables (one of the table containing Data Type "MediumBlob"). But when I read the data (by Linking) through MSAccess (2003 version), why the data containing the Mediumblob type can not view ?. Could somebody help me why ? What am I supposed to do ?. Thank you.

You are hijacking an old thread.

Please post this as a new thread.