Alpha Video Training
Results 1 to 5 of 5

Thread: Export to Excel

  1. #1
    Member
    Real Name
    Joseph Manners
    Join Date
    Jun 2006
    Posts
    16

    Default Export to Excel

    Based on everything I do when I export records from Alpha to Excel I am under the record constraints of the old version of Excel. I cannot export directly to Excel more than 70000 records. Is there a work around other than doing mutiple exports?

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,308

    Default Re: Export to Excel

    If you are using a more recent version of Excel have you tried exporting to "remote database, using AlphaDAO" ?

  3. #3
    Member
    Real Name
    Joseph Manners
    Join Date
    Jun 2006
    Posts
    16

    Default Re: Export to Excel

    No I haven't. I will look up with help what AlphaDAO is ... thank you for the tip.

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,308

    Default Re: Export to Excel

    Exporting to a remote database using AlphaDAO is an option Alpha presents if you use the genie to create your export operation.

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Export to Excel

    If you are using up to Excel 2003 you have the option to use Alpha's ole methods to open the dbf and save it as .xls. That way you can export as many records as your Excel version supports. I think there are some examples in the code archive.

Similar Threads

  1. Filling datasheet in excel template possible with export to excel FP?
    By cptutrecht in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 04-28-2011, 07:23 AM
  2. Export to Excel - Export Hidden Fields not working
    By iviowa in forum Application Server Version 10 - Web/Browser Applications
    Replies: 5
    Last Post: 02-21-2011, 04:35 PM
  3. Excel Export Help
    By chrisdc1 in forum Alpha Five Version 8
    Replies: 1
    Last Post: 11-18-2008, 01:06 AM
  4. Import excel then export to excel
    By popellis in forum Alpha Five Version 8
    Replies: 4
    Last Post: 04-03-2008, 10:13 PM
  5. Export 2 Excel
    By crimmelcp in forum Alpha Five Version 7
    Replies: 14
    Last Post: 07-18-2007, 08:40 PM

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
  •