Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005

    Unanswered: Export to Excel has data error

    I am using Paradox 9, and exporting tables to Excel 97. The export builds the file form the table, but information I have in one of the columns, for dates, does not move over correctly. The dates are shown in the following format:
    When the Excel file is built, the data in the column is 39672 instead of 11/10/2005. If I correct the data and import back to Paradox the data is correct, but I don't want to have to change the data each time I export a table to Excel.
    How can I fix this problem? Any suggestions would be appreciated.

  2. #2
    Join Date
    Aug 2003
    Bologna - Italy
    You should export using CSV format with quotes around fields.
    The only failure is not trying to do it.

  3. #3
    Join Date
    Sep 2003


    During the export make sure that the field is exported to Excel as a date.
    And format the excel column as a date. Both excel and Paradox store dates as a number ######.#### and convert it for formating. This is how date time calculations are achieved. (It started with lotus and dbase.) I believe they have standardized on the beginning number which is not related to the Death or Ascension of Christ.


Posting Permissions

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