Post by buttlerkid » Wed May 02, 2012 5:26 pm

Is there a method to do this ? I have like 6000 rows in excel, and it would take months to import it into the sql database.

For example there are : Column A and Column B in excel and I'd like to import it into Column A and Column B into the products table.

Thanks!

New member

Posts

Joined
Thu Mar 29, 2012 8:37 pm

Post by inspirio » Wed May 02, 2012 6:00 pm

What exactly have in this rows????

Image


User avatar
New member

Posts

Joined
Fri Feb 17, 2012 9:11 pm

Post by buttlerkid » Fri Jun 01, 2012 4:48 am

I already managed to do it. i made as much columns in excel as it had in the tables, saved it in a cvs format and imported it all into the specific tables.

New member

Posts

Joined
Thu Mar 29, 2012 8:37 pm
Who is online

Users browsing this forum: Majestic-12 [Bot] and 19 guests