Export To Excel

Hi Folks,

Just to say I like the programme but I have one query.

Why oh why can't there be a simple export to Excel or .XLS.?

I want to put my music lists on a spread sheet so that I can sort them by column in my own way.

Have I missed something?

I want the program and will be happy to pay but not unless I can export to .XLS.

Lastly, I've tried opeing HTML in Excle but it makes a dog's dinner of it all.

Tut...if life could be simple.

Thank You in advance and take care.

What you can do, with considerable flexibility, is export to plain text, then import THAT into Excel. In List View, select the records that you want to export. Then click Import/Export in the OCD Database menu and select the Plain Text option. The rest should be easy.... (!) Good luck.

From list view:
1. Select the first record in the list.
2. Scroll down to the last record press the Shift key and then select the last record in the list.
3. Right-click and choose Copy As Text from the cursor menu.
4. Fire up Excel (ussing Office 2007 here)
5. Right click cell A1 (on a blank worksheet) and choose Paste Special from the cursor menu. Select Text As source and click OK.
6. Done.

You can take it one step further. Fire up Access and import the XLS or create a linking table for future updates to the XLS.
Use Access to parse the data building a relational DB.

Quote:

---

Originally Posted by CADru

From list view:
1. Select the first record in the list.
2. Scroll down to the last record press the Shift key and then select the last record in the list.
3. Right-click and choose Copy As Text from the cursor menu.
4. Fire up Excel (ussing Office 2007 here)
5. Right click cell A1 (on a blank worksheet) and choose Paste Special from the cursor menu. Select Text As source and click OK.
6. Done.

You can take it one step further. Fire up Access and import the XLS or create a linking table for future updates to the XLS.
Use Access to parse the data building a relational DB.

---

Great! Much easier - good thinking!