Closed Thread Icon

Topic awaiting preservation: Next struggle...Access, MySQL and PHP (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=12322" title="Pages that link to Topic awaiting preservation: Next struggle...Access, MySQL and PHP (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: Next struggle...Access, MySQL and PHP <span class="small">(Page 1 of 1)</span>\

 
Thumper
Paranoid (IV) Inmate

From: Deeetroit, MI. USA
Insane since: Mar 2002

posted posted 07-22-2002 09:09

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).]

DmS
Paranoid (IV) Inmate

From: Sthlm, Sweden
Insane since: Oct 2000

posted posted 07-22-2002 11:32

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 }-

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 07-22-2002 12:19

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.

« BackwardsOnwards »

Show Forum Drop Down Menu