NYCPHP Meetup

[John Lacey]

Josh McCormack wrote:
> Exporting it to CSV wouldn't include the structure, though. Is there a 
> way to dump a MS Access DB to SQL + data the way you easily can with 
> MySQL so you could just transfer it?
> 
> Could be useful. Say if you wanted to have an office LAN MS Access db 
> with client data to access with Outlook, and you could sync it with 
> MySQL to have it available for web based apps.


here's a few links:

http://www.mysql.com/portal/software/item-266.html

http://www.convert-in.com/acc2sql.htm

http://www.fileheaven.com/Access-to-MySQL-Pro/download/975.htm


I didn't check if they were all free/shareware, but I'm sure they have 
demo downloads