Results 1 to 3 of 3

Thread: Data conversion

  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: Data conversion

    Hi all,

    Am working on the transfer of data from a Paradox system to an Access/SQL version for a client.

    I can open several tables through access directly, and have no problems with them. However, the main tables aren't readable - if I open the file through notepad, I see the data as follows:

    %    5   KELLY S  :Numerous lesions on dorsum of hands. One growing larger.
     V? Actinic Keratosis. Also possible S.C.C. lt hand. Biopsied and sent
    for histology.
     

    There is an export routine that converts this data to a raw text format, but it only transfers certain records, and I need them all. The file is saved with a .dat extension.

    Does anyone have any idea if this is indeed a Paradox file, as the main database definitely is. If so, is there any way of decrypting the data??

    Would really appreciate any info on this!!!

  2. #2
    Join Date
    Dec 2003
    Location
    New Zealand
    Posts
    17
    You should be able to use ODBC to open your Paradox tables in Access.

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas
    Posts
    182

    Re: Data conversion

    Access ODBC has some problems with later versions version of Paradox. You may need to get a copy of Paradox and export the files to a Tab Delimited format, assuming what you have is a runtime app and do not have access to the full program. The other possibility is that some of the fields are memo/blob fields which would contain mixes of binary and text if translated into ascii or ansi data improperly.

Posting Permissions

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