Alpha Video Training
Results 1 to 3 of 3

Thread: Export to Excel

  1. #1
    Craig Johnson
    Guest

    Default Export to Excel

    I need to export data from A5 into Excel, all goes fine but I'm having problems with memo fields, especially if they contain lots of data. It seems only to export the first 255 characters at a guess and the remainder are little squares. I need all the data within the memo field to move across.

    Any ideas??

  2. #2
    Member
    Real Name
    Doug Chanley
    Join Date
    Apr 2000
    Posts
    563

    Default RE: Export to Excel


    Hi Craig,

    I experienced the same thing you did. However, I exported the table to a comma delimited text file then opened the text file in Excel & all the text in the memo field was displayed....

    I checked the format of the cell that contains the memo text & it is formatted as "General", so I am not quite sure why the text does not display when using the "quick export to excel" but does when read from a text file???


    probably not what you wanted to hear but for the short answer it may be what you need to do....


    good luck

    doug

  3. #3
    John Magno
    Guest

    Default RE: Export to Excel

    You can also import your A5 file into Excel using the Foxpro ODBC driver.

Similar Threads

  1. Export to Excel
    By gagsoft in forum Alpha Five Version 6
    Replies: 7
    Last Post: 04-01-2006, 07:28 PM
  2. Export to Excel
    By Bob Whitaker in forum Alpha Five Version 5
    Replies: 0
    Last Post: 07-14-2005, 12:53 AM
  3. Export to Excel XP
    By robert cook in forum Alpha Five Version 5
    Replies: 1
    Last Post: 11-12-2004, 01:09 PM
  4. Export to Excel
    By Mike Reed in forum Alpha Five Version 1
    Replies: 3
    Last Post: 07-14-2004, 02:27 PM
  5. Quick Export To Excel
    By Elke in forum Alpha Five Version 4
    Replies: 4
    Last Post: 03-27-2001, 09:53 AM

Bookmarks

Posting Permissions

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