Creating DBF & CDX Files

[GregGlenn_(Guest)]

I have a lot of data in TXT files. What is my best method for creating DBF and CDX files to allow me to run reports on that data using R&R ?____Thanks,__Greg__

[kfleming]

The SQL version of R&R will allow you to directly report on text files.__Otherwise you would need an application (like Excel or Access) to import the text and then save it as a DBF.____Kathleen__R&R Support

[GregGlenn_(Guest)]

Kathleen,__ Does the SQL version allow me to set the scope of my Master file if it is a text file and can I create relationships to other text files ?____ Am I correct in assuming that even if I create a DBF from my TXT file using Access, I still need a CDX to set the scope and build relationships between files. I am talking about the Xbase version here.____Thank you for your reply,____Greg

[kfleming]

The SQL version does not support scope.__But the Xbase version 9 and above allows you to build indexes on the fly so that you can join any DBF tables without needing pre-existing indexes.____Kathleen__R&R Support

[GregGlenn_(Guest)]

Kathleen,__ That sounds good. Thanks for your help.__Greg__