Importing to MySql?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
williery10
Forum Newbie
Posts: 15
Joined: Thu Feb 20, 2003 4:23 am

Importing to MySql?

Post 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
PingLeeQuan
Forum Commoner
Posts: 58
Joined: Tue Sep 03, 2002 8:08 am

Post 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
rodrigocaldeira
Forum Commoner
Posts: 27
Joined: Wed Mar 05, 2003 6:40 pm
Location: Brazil
Contact:

Post 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.
williery10
Forum Newbie
Posts: 15
Joined: Thu Feb 20, 2003 4:23 am

Post by williery10 »

Thanks guys,
that was really help
Williery
Post Reply