+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

Paradox Data Export

  1. Paradox Data Export

    Hi, I have a quick, very basic question. I am trying to acquire some
    data for research purposes. The DB administrator claims that the data
    are stored in Paradox and that it would be extremely labor intensive to
    extract them. I am not a DB administrator, but that seems to be an
    inaccurate representation. From what I have been able to find in this
    group, Paradox can export .txt or .csv or even Access files. Is this
    correct? Is it a lot of work to do such an export?

    Thanks for your help and sorry about the basic post!


  2. Re: Paradox Data Export

    It is not a lot of work to use Paradox to export a Paradox table from
    the Paradox format to another format. It is not a lot of work to
    create a script that will do this for all tables in a given dir/set of
    dirs.

    It is slightly more work if these tables contain memo (BLOB) fields.
    If you want to retain formatting in a formatted memo field, that is a
    bit more work. If you want to extract fields from the other BLOB-type
    fields (if there are any), that's a little more work.

    To figure out a data model and/or do queries to convert the data into
    a structure other than its default could be a lot of work.

    To do any of the above in any program other than Paradox will be
    harder than in Paradox. How hard will depend on the program.

    Liz


    Bob wrote:
    >
    > Hi, I have a quick, very basic question. I am trying to acquire some
    > data for research purposes. The DB administrator claims that the data
    > are stored in Paradox and that it would be extremely labor intensive to
    > extract them. I am not a DB administrator, but that seems to be an
    > inaccurate representation. From what I have been able to find in this
    > group, Paradox can export .txt or .csv or even Access files. Is this
    > correct? Is it a lot of work to do such an export?
    >
    > Thanks for your help and sorry about the basic post!


  3. Re: Paradox Data Export

    and....

    If you don't have Paradox installed... you can use Excel Spread Sheets to
    "Import" Paradox Tables into Excel.

    It simply requires that you have installed the Paradox import filter (an
    extra add-in provided by Microsoft on your Excel CD ROM and is not
    'normally' installed by using the "Typical" installation option).

    If you don't have the Paradox Import option available, simply place your
    Excel CD into the CDROM and choose ADD features (or software... or what ever
    the option provides)... then select the Paradox Import/Export option to add
    it.


    --
    ....
    `..`..`-> rodney





  4. Re: Paradox Data Export

    It's probably not an "Excel CD ROM".... but probably a "Microsoft Office" CD
    ROM.

    --
    ....
    `..`..`-> rodney



  5. Re: Paradox Data Export

    Bob wrote:

    > Is it a lot of work to do such an export?


    Not if you have available just about any Windows machine, which have an ODBC
    driver that'll usually do it. If you have Paradox or some BDE application,
    even better.

    I'd be curious to know what would be so labor intensive about it.

    --
    Larry DiGiovanni
    Digico, Inc.
    IT Consulting and Staffing Solutions
    www.digicoinc.com
    Check out www.thedbcommunity.com for Paradox resources.



  6. Re: Paradox Data Export

    On Wed, 26 Apr 2006 12:36:20 -0400, Larry DiGiovanni wrote:

    > Bob wrote:
    >
    >> Is it a lot of work to do such an export?

    >
    > Not if you have available just about any Windows machine, which have an ODBC
    > driver that'll usually do it. If you have Paradox or some BDE application,
    > even better.
    >
    > I'd be curious to know what would be so labor intensive about it.


    A police chief told me that when he once got this sort of response from his
    city's IT types, he had a notary put them under oath and deposed them on
    the spot. Suddenly, they figured out how to do what he wanted.

    A bit OT, but kinda neat, I thought.


    Jim Hargan

  7. Re: Paradox Data Export

    Probably more a matter of the DB administrator's attitude/knowledge than
    any limitations of Paradox.

    Larry DiGiovanni wrote:

    > I'd be curious to know what would be so labor intensive about it.
    >


  8. Re: Paradox Data Export



    Do you know how many different tables the data is in ?
    Do you know which fields and what tables the data is in ?
    How many fields do you need to export ?
    Does the exported information have to be in specific format ?
    Is this one time shot or need to do it repetively ?
    Is it strictly an extract, or do you need to do summaries first ?
    Once you have the data, what will you do with it ?
    Export to fixed width or separated ?
    How large is the data ? How many rows ?
    Can you just copy n paste to excel ?

    You say the data is in paradox tables,
    but you dont mention if you own pdox.
    Do you own pdox , and if so, what version ?

    If it is a single table, and you own pdox,
    it might be simple,
    but I think it is difficult to say for sure without more information.

    If you dont own pdox,
    or the output format is not simple delimited,
    then it isnt quite so simple,
    and the complexity starts growing from there.

    That being said, there are many people on this list
    who can roll their own exporting code in their sleep.

    Good luck
    Robert Wiltshire





  9. Re: Paradox Data Export

    On Wed, 26 Apr 2006 12:30:31 -0400, "Rodney Wise"
    wrote:

    >and....
    >
    >If you don't have Paradox installed... you can use Excel Spread Sheets to
    >"Import" Paradox Tables into Excel.
    >
    >It simply requires that you have installed the Paradox import filter (an
    >extra add-in provided by Microsoft on your Excel CD ROM and is not
    >'normally' installed by using the "Typical" installation option).
    >
    >If you don't have the Paradox Import option available, simply place your
    >Excel CD into the CDROM and choose ADD features (or software... or what ever
    >the option provides)... then select the Paradox Import/Export option to add
    >it.


    I tried to import Paradox tables into Access, and it told me they weren't
    Paradox tables.


    --
    Steve Hayes from Tshwane, South Africa
    http://www.geocities.com/Athens/7734/stevesig.htm
    E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

  10. Re: Paradox Data Export

    Maybe they weren't Paradox tables... all DB files aren't necessarily
    Paradox tables.


    --
    ....
    `..`..`-> rodney



+ Reply to Thread
Page 1 of 2 1 2 LastLast