How to import catergories from a csv ???

[---kate---]

Hi,

I have an csv of the catergories I need for my shop which looks like this:
categories_id,parent_id,name
"17","0","Toys"
"18","6","Stationery" etc...

How can I import these into the database? Or how would I go about writing an sql statement to do so?

I need the categories to keep the id's in the csv as I am using them for easy populate for the product csv.

Any help appreciated!

[---kate---]

Decided to do it the long way & import manually.

[JollyJim]

For future reference:

INSERT INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`, `categories_status`) VALUES
(17, NULL, 0, 0, '2010-04-15 22:34:34', NULL, 0),
(18, NULL, 6, 0, '2010-04-15 22:34:36', NULL, 0),

INSERT INTO `categories_description` (`categories_id`, `language_id`, `categories_name`, `categories_description`) VALUES
(17, 1, 'Toys', ''),
(18, 1, 'Stationary', ''),