Topic awaiting preservation: Next struggle...Access, MySQL and PHP (Page 1 of 1) $Pages that link to <a href="https://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 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 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 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.

Topic awaiting preservation: Next struggle...Access, MySQL and PHP (Page 1 of 1) $Pages that link to <a href="https://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 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 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 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.