Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: phranque
Although I have worked with flat file DBs and have some experience with MySQL, I've not worked with Access much.
What would be the easiest way to get data from Access into MySQL tables? The site is currently on a NIX server, if that makes any difference. I would probably use DBMan SQL, or a similar product for the front end. Thanks.
BTW, if you use IIS, or anything else that can talk to an ODBC driver, you could leave it in Access and get the data directly into the database from the web site.
I don't know if this includes mySQL but it works with SQL Server, Oracle, Sybase and others. Data loading becomes a snap because you simple Export using a built-in capability of Access.
If you move the Access database (tne .mdb file) to the server, remember that the server needs to have Access installed on it to work properly.
LOAD DATA [LOW_PRIORITY ¦ CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE ¦ IGNORE]
INTO TABLE tbl_name
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]