Results 1 to 4 of 4

Thread: Export To Excel

  1. #1

    Default 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.

  2. #2
    Join Date
    Dec 1969
    Location
    Nottingham, England
    Posts
    263

    Default Re: Export To Excel



    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.

  3. #3
    Join Date
    May 2006
    Location
    3rd PFTS
    Posts
    1

    Default Re: Export To Excel

    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.

  4. #4
    Join Date
    Dec 1969
    Location
    Nottingham, England
    Posts
    263

    Default Re: Export To Excel

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •