MySQL

ccandeland · Sep 3rd, 2007, 20:00

Hi

I am working on an online store with 10,000 products I have them currently in an excel file. It would be great if someone could help me upload this file to a mysql database on my site host. I have tried to upload a text file to phpmyAdmin but it gives an error. Do I need to convert to mysql before I upload and is there software to do this?

Thanks

Chris

dab42pat · Sep 3rd, 2007, 20:32

Hi

Take a look at this. Could be what you are looking for. Never used it myself so cant comment on programme.

http://www.shareup.com/Excel-to-MySQL-download-43.html

ccandeland · Sep 3rd, 2007, 21:27

Quote:

Originally Posted by dab42pat

Hi

Take a look at this. Could be what you are looking for. Never used it myself so cant comment on programme.

http://www.shareup.com/Excel-to-MySQL-download-43.html

Thanks for the help i tried that one but they wanted money and as I am tight fisted I looked for another way and found this http://www.bullzip.com/products/a2m/info.php

Now got it working!

Thanks

Chris

dab42pat · Sep 3rd, 2007, 21:31

Glad its sorted.