.DBF to .DB to PTwin errors

[sampofin]

Is anyone familiar with a program called PTwin by Blackbear. I've been trying to import data, and have run into some problems. What is a primary index and secondary index? The original data came from ESRI products (arcview) exported to Excell. The original data from PTwin (a blank spreadsheet) was exported by paradox to Excell. I used copy past for the data transfer, then cleaned up the data. Used paradox to import the excell file back to a .db format. now all I get are errors; out of date secondary index, out of date primary index, can not find the file....

Any ideas would be appretiated. I'm out of ideas, tricks, resources....

 

[footpad]

Sampofin,

Indexes are used to sort data in Paradox (and dBASE) tables. A primary key (or index) is the main organization and secondary indexes can be thought of as alternate sorts. To display data in different sort orders, you need secondary indexes for each order you wish to use.

Now, having said that, you're currently going through a lot of hoops to transfer your data. I'd try to simplify the process by using comma-delimited text (CDF) files as the interim format, instead of trying to to transfer data in a binary spreadsheet format.

This should allow you to take Excel out of the loop and might help obviate the need for these indexes.

Hope this helps...

-- Lance