Problem with new database

[ilovetofly]

I've attempted to create a new database and I thought that I had done it correctly. But when attempting to import it I get an error message which states the following: "Invalid catagory on line 1. See the log file for more information".
I'm using EXCEL 10 to create the database and saved it as a csv file. But when I save it I get this message: NZ_SID_STARS_DBASE.cvs may contain features that are not compatible with CSV. 
  1. To keep this format, which leave out any incompatable features, click Yes.
  2. To preserve the features, click No. Then save a copy in the latest EXCEL format.
  3. To see what might be lost, click Help."

When I click on Help, I don't see what is the problem. If I click on save, I get the message as noted above. If I click on No, what would be the latest EXCEL format? Do I need a newer version of EXCEL?

I've included the file for help in learning what the problem is.

Thanks,

Jim D.

[tim arnot]

The Category column needs to be at the start of each line, not in the position where you have it (it's different to what you see in the Manage VRPs dialog), otherwise it looks okay. If you move the column in Excel, and resave, it'll import fine.

Just ignore that warning: Excel is merely whingeing that you're not using an MS proprietary format...  ::)

[ilovetofly]

Thanks Tim, that did it.

Jim D.