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!

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:

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

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

--
....
`·.¸¸.·´¯`·.¸¸.·´¯`·-> rodney

Bob wrote:

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.

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

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

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

Larry DiGiovanni wrote:

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

On Wed, 26 Apr 2006 12:30:31 -0400, "Rodney Wise"
<NSpamPlease_rodney1 (AT) bellsouth (DOT) net> wrote:

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

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


--
....
`·.¸¸.·´¯`·.¸¸.·´¯`·-> rodney