I have a client that has an existing Access database that is currently about 8 megs in size with about 8 tables and 200 fields. They want the DB on their website, with a password protected front end so their remote offices can make changes and additions- currently the people in the remote offices email their info to the main office and the changes/ additions are made there.
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.
you can export the access info to a csv file and then use the following sql command
LOAD DATA [LOW_PRIORITY ¦ CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE ¦ IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)]