Liveware Publishing Support Forum

__This problem statement is a little long but..here goes...____I have a large number of Excel and Dbase files that currently share a common record layout (field names and widths, etc). I initially created my first report using a master table based on the Xbase file format. I can easily replace the original master table with other Xbase tables, re-run the report and get the expected results. However, since all FUTURE data files will soon be provided in an Excel format, I tried using the RRSQLWIZ.exe program expecting to be able to use the time and effort from the Xbase effort as the basis for a new master SQL report. Then al future Excel files could be substituted as the need arises...Here are the steps that lead to my problem:____ Launch the RRSQLWIz.exe utility program__ Change platform__ Create new data source__ Select MS Excel driver__ Select a specific Excel file and directory__ Specify data source name__ Use existing tables and columns__ Pick an existing *.rrw report to convert (in my case there is only one *.rrw report to choose)____ Store report in original folder____Immediately an Error Message Box pops up "File Read Error..."____Status report log shows:__ reports processed = 1__ reports converted = 0______It appears that the Wizard follows most of the steps that are also required when you first create any new SQL report in the designer window_____My question is:__ When should I use the SQL wizard tool?__ What is the most efficient way to substituting master tables when using the SQL version?____My end game is to use a control file and automate the substitution process. I want to work thru at least one master table substitution procedure myself to under stand the logic before using any control file.______Thanks for any help on this item_____Mike P.__Buffalo - NY

Try using the RRCONVERT.EXE instead and pick the RRW to RSW radio button. The converter will prompt you to select a datasource for the RSW and you should be able to open the report. It will likely tell you however, cannot open <tablename>. Try another data source? Answer no to this question. It will then prompt Reselect master file? Say yes and you should be able to manually reselect the table.__Once you do this and save the report, you will not see these errors on re-open.____Kathleen__R&R Support