Page 1 of 1
Creating DBF & CDX Files
Posted: Mon Oct 28, 2002 2:10 pm
by 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__
=> RE: Creating DBF & CDX Files
Posted: Mon Oct 28, 2002 10:37 pm
by 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
==> RE: Creating DBF & CDX Files
Posted: Wed Oct 30, 2002 12:33 pm
by 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
===> RE: Creating DBF & CDX Files
Posted: Wed Oct 30, 2002 1:10 pm
by 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
====> RE: Creating DBF & CDX Files
Posted: Wed Oct 30, 2002 3:30 pm
by GregGlenn_(Guest)
Kathleen,__ That sounds good. Thanks for your help.__Greg__