Populate MySQL table with Excel Data

[Edmontonabguy]

I have an existing website with CMS and am trying to add pages to the site directly through MySQL.  I have a long list of Data in Excel (450).  I would like to know the numbering structure I should use before i try to import all the data.
I did have some success with this, just some of the links in the menu are mixed up.
Cheers
Art

[cyberman]

Why do you want to import excel data to mysql?

It's IMHO a lot easier to export data as csv and show it via plugin ...

[Edmontonabguy]

I agree, the data I have only uses 1 field and I need to add the directory structure ( I think)????

[cyberman]

Not sure, what you mean - can you tell us something more?

[Edmontonabguy]

Here are a few lines from the CSV file I exported;

"81,SERVICE AREAS,content,1,-1,16,8,8,0,CITIES,service-areas,1,NULL,html,1,1,81.00,service-areas,content_en\,Sidebar,NULL,NULL,NULL,1,10/13/2007 14:54,10/15/2007 11:50
82,ACME,content,1,81,20,2,8.00002,0,ACME WEDDING DJ,acme-wedding-dj,1,NULL,html,1,1,81.82,service-areas/acme-wedding-dj,"content_en,Sidebar",NULL,NULL,NULL,NULL,1,10/16/2007 22:37,10/16/2007 22:37
83,AIRDRIE,content,1,81,20,3,8.00003,0,AIRDRIE WEDDING DJ,airdrie-wedding-dj,1,NULL,html,1,1,81.83,service-areas/airdrie-wedding-dj,"content_en,Sidebar",NULL,NULL,NULL,NULL,1,10/16/2007 22:37,10/16/2007 22:37"

Under the service area heading I am trying to add multiple cities, I have a template that is populated with the name of the city.  I was thinking I could add all the cities into this file, import it and be done.