Topic awaiting preservation: Next struggle...Access, MySQL and PHP

Is there a way to convert entire Access or Excel databases into something MySQL can understand? The problem begins with having approx. 3,000 products for sale and I would hate to have to input those all manually. Are their INPUT commands that Access can generate so I can just run a simple SQL query? I will be using phpshop for this, so any help as to how I can preformat the table before such a process for easier categorization would help. Is this a comma-separated-values deal? HELP!!



[This message has been edited by Thumper (edited 07-22-2002).]

I guess you could set up an ODBC-connection to you mysql-db, then use the export to ODBC-Databases function in access (2000). Havn't tried it, but it seems like it should work.
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

worst case scenario:
have access put out into a comma seperated values file,
then write a php script that converts those into the insert queries (adding quotes and stuff). run the queries. > still faster than reentering the information. but might take a day.