Page 1 of 1

Data File

Posted: Sun Jan 23, 2005 1:03 pm
by WAS
I^m just starting out with R&R V11. I would like to be able to put a text file in MS Excel, make corrections and use R&R to report against the data. Should I move the data from Excel to a database like Dbase or Access first or could I keep the data in Excel?

=> RE: Data File

Posted: Sun Jan 23, 2005 5:52 pm
by kfleming
I would save the Excel file in DBF format and then use the Xbase version of R&R. The advantage of Xbase is that each column will have an explicit field name and data type which may not always be the case with Excel.____Kathleen__R&R Support

==> RE: Data File

Posted: Tue Feb 15, 2005 11:14 pm
by WAS
Thanks for your help. I have been saving Excel files in dbase3 format and the reports have been turning out great! I have ordered__Visual Dbase 5.5. Would you know if I can save the data in this database program and run against the files?

===> RE: Data File

Posted: Wed Feb 16, 2005 4:02 pm
by kfleming
The only problem you will have with dbase 5.5 are the datetime fields which R&R currently does not support.____Kathleen__R&R Support

====> RE: Data File

Posted: Thu Feb 17, 2005 3:49 pm
by WAS
Kathleen, thanks. I don^t do much with the date or time.