Page 1 of 1
Converting Xbase report to SQL
Posted: Wed Aug 19, 2009 4:47 am
by pbla1_wcc
[updated:LAST EDITED ON Aug-19-09 AT 04:48 AM (EST)]I^m trying to convert an Xbase report to SQL. I^ve imported the DBFs into an Access Mdb keeping the table & field names unchanged, but when I run the conversion utility I get the error message:____ERROR: File read error on <filename>.RRW____with every RRW report I^ve tried so far.____All of the reports run without problems in the Xbase version.____I^m using v11.0.006.____Has anyone else had problems converting reports? Or found out how to fix this one?____Thanks,__ Peter
=> RE: Converting Xbase report to SQL
Posted: Wed Aug 19, 2009 7:15 am
by pbla1_wcc
More info: I^m using the "Convert Xbase reports to SQL" entry on the menu, not the "report Converter" utility.____If I try using the utility (converting the report to SQL while still using the dbase files)it converts the report, but then gives an error ____DB access:[Microsoft][ODBC dBase Driver]External table is not in the expected format____which is why I was trying the "Convert..." option!
==> RE: Converting Xbase report to SQL
Posted: Wed Aug 19, 2009 2:56 pm
by kfleming
Do you get the error when you try to open the converted report in the SQL Report Designer?____Kathleen__R&R Support
===> RE: Converting Xbase report to SQL
Posted: Mon Aug 24, 2009 4:57 am
by pbla1_wcc
Yes - R&R SQL just says "Invalid report type". If I click OK then I get "Library error (cannot open file) reading report <name>.rsw".
====> RE: Converting Xbase report to SQL
Posted: Mon Aug 24, 2009 7:53 am
by kfleming
Can you email the problem RRW file to me?____Kathleen__R&R Support__livesupport@livewarepub.com