How to create an index on a DBF file

[tuigvlieg]

I am using Crystal report version: 8.5.3

I have a document that can be downloaded from a web page as CSV file. I open this file and save it as DBF 4 file.

I load this file into a Crystal reports table via add tables option Find database files. I browse to the correct location and select the correct DBF file. The DBF file is loaded into Crystal reports now.

The loaded table is not linked to a database table but I should like to match some fields between the tables. I think the best is to have the database table as lead and then search in the created table. But then I need to create an Index. When i right click on the created table then I have the option add index. But then Crystal is asking for a file containing the index. What is this and how do I created this file? Is there an easier solution for what I am doing?

Rgds, GJ

 

[tuigvlieg]

I forgot to say that the file is coming from an Microsoft environment and the table is running a Oracle database.

 

[qii]

There are FREEWARE utilities that let you create a DBF index.

As a start, look here...

http://www.vistasoftware.com/apollo_utilities.asp