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
Importing to MySql?
Moderator: General Moderators
-
PingLeeQuan
- Forum Commoner
- Posts: 58
- Joined: Tue Sep 03, 2002 8:08 am
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
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:
-
williery10
- Forum Newbie
- Posts: 15
- Joined: Thu Feb 20, 2003 4:23 am