[marketingsolutions]

I have a huge catgory and sub category list from my client and instead of adding them one by one is there anyway to upload a csv file directly into the sql database so the sub categories get put into the correct category?

Regards

Stuart

[marketingsolutions]

I think I deserve a coffee!

I've done it.

If anyone wants an excel template and some more info let me know.

All i did was to use formulas in excel and use the "insert into" sql statement and then exported the cell data to a sql file.

I then imported the sql file into the database and it worked.

If you have huge category lists like I do then this is fantastic.