Exporting Data

[smed]

I am able to export data from a table or query into a paradox data file, but my problem is that I need to create a paradox index file for the paradox data file.

The application which uses the paradox data automatically inserts a Autonumber column before the data columns if an index file has not been created.

Smed

 

[The_Doc_Man]

Unless PARADOX publishes its internals in a way consistent with the Component Object Model (COM) standards, you cannot do this via Export. You must be able to use COM methods to open PARADOX as an application and create the index you want that way, then remove the column you didn't want created.

You may have to do some digging. I've never tried working with PARADOX at that level before. You'll need either a .DLL or a .OLB or a .OCX or SOMETHING that you can activate as an Access reference (Tools>>References and browse for it....)

 

[smed]

After further investigation, it would appear that all I need to do is set a primary key in the paradox data file, however linking to a paradox db via msaccess is only read-only.

Anyone know of a way around this ?

Smed