183 Posted January 13, 2005 Posted January 13, 2005 Hi, I have an MS excel document with 2,000 products on it that I need to add to my store. I could sit here and add them one by one and slowly go insane or....... Is it possible to change the file into an SQL file and uplaod it direct to the database products table? Any help would be great! I understand that in the table there are 13 fields and that each of these has to be filled and Im sure it has to be possible! Just cant get my head round how.... How to write the SQL for the 13 fields including the details for the 2,000 products!
183 Posted January 13, 2005 Author Posted January 13, 2005 And I think I just found the answer!!!! http://www.convertzone.com/net/cz-excel-to...l-excel-sql.htm is there a better version?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.