Page 1 of 1

Importing to MySql?

Posted: Fri Mar 07, 2003 6:51 am
by williery10
Hi,
just have a couple of MySql queries.

1) How can I get a visual basic program to talk to MySql

2) How to I perform an import from MS Access to MySql

3) How can I the tables on a MySql Db on a Windows machine to a MySQL db on the Linux webserver.

4) There is a Blob and Text field type for mySQL which is great, is there one for MS Access.

If anyone can point me in the right direction on this or recommend any reading material it would be great.

CHeers
Williery

Posted: Fri Mar 07, 2003 7:59 am
by PingLeeQuan
I am not familiar with VB connection to MySql, but PHP, for example, has API calls to let you connect to the database. Look into mysql_connect in the API section of VB

2) You can use the EXPORT utility on MS Access from the file menu
then click on Other ODBC databases option form the save as.

Choose a name for your table
Then it will take you to the ODBC configuration of the database. Make sure you have one already. If not, you can create an ODBC dsn at that time.... consult the access database help on this one

NOTE: be careful. if you have a BOOLEAN or a YES/NO field, the export utility will export it as a bool (which converts to tinyint on the database). Then you have to change the code to correspond.

Hope that helped

Posted: Fri Mar 07, 2003 8:04 am
by rodrigocaldeira
To conect to a MySQL using VB you can install the MyODBC Driver, and then use the syntax to conect to a ODBC Driver.

Posted: Tue Mar 11, 2003 4:45 am
by williery10
Thanks guys,
that was really help
Williery