MySQL Forums
Forum List  »  Newbie

runing mssql2mysql / msacc2mysql db converter tool
Posted by: jerry stark
Date: October 20, 2009 12:30AM

I have copied the file msacc2mysql.txt from www.kofler.cc/mysql/msacc2mysql.txt per the mysql web page on converting a Microsoft access db to mysql.
I have not used VBA before. Using Microsoft XP. mysql 5.1 excel 2003 sp3 vb 6.5
I am getting a compile error: expected: line number or label or statement or end of statement.

This is the code I changed in the file,
Can anyone familiar with VB6 give me a hint on how to debug it????

Const OUTPUT_TO_FILE = 1 '1 --> write file (latin1 encoding);
'0 --> connect to MySQL, execute SQL commands

'output file (only needed if OUTPUT_TO_FILE=1)
Const OUTPUT_FILENAME = "H:\mysql\access03db.sqltxt"

'M$ Access
'database file name
Const MSA_DB_NAME = "h:\Projects\access03db.mdb"

'MySQL database settings
Const NEW_DB_NAME = "access03db" 'name of new MySQL database

'connect to MySQL (needed if OUTPUT_TO_FILE=0)
Const MYSQL_USER_NAME = "" 'login name
Const MYSQL_PASSWORD = "" 'password
Const MYSQL_HOST = "localhost" 'if localhost: use "localhost"
Const MYSQL_PORT = 3306 'change if you use another port

Const DROP_DATABASE = True 'begin with DROP dbname?
Const MAX_RECORDS = 0 'max. nr of records in table (0 for all records)
Const VARCHAR_MAX = 255 'max. nr of characters in VARCHAR
'255 for MySQL <=5.0.2
'ca. 32000 for MySQL >= 5.0.3 (depends on char. set, max. 65535 bytes)
Const TABLE_ENGINE = "MyISAM" 'MyISAM or InnoDB
Const CHARSET = "utf8" 'character set for all text columns
Const COLLATION = ""
' Something is happening here with editing, won't keep it together----
'collation; leave empty if you want to ' use the default collation for
'the specified character set
' ------
Const MyODBCVersion = "MySQL ODBC 5.1 Driver"
'for MyODBC 2.51.* use "MySQL"

Options: ReplyQuote


Subject
Written By
Posted
runing mssql2mysql / msacc2mysql db converter tool
October 20, 2009 12:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.