Liveware Publishing Support Forum

Hello Again...____After building my initial SQL report using an ODBC link to my Excel data file, I tried to substitute another Excel file as the master table that has a common record layout. I previously created a series of ODBC data sources to these common data files to make these data file substitutions but consistently get error messages similar to "....MS Jet database engine could not find object. Make sure the object exists and that you spell its name and the path name correctly..."____Here is the question: in the process of creating the ODBC connections I did not specify any path since all files were in a common directory. Is this part of the problem?____Also - all ODBC connections were prepared using the same Excel driver. I did see another choice called _MS Excel _ Treiber_ but did not select it. Sounds like an Italian tenor...but is probably not. When would you use this driver as a secondary choice?____I also noticed that when I defined a new named range inside the Excel file that this change was also reflected in the Master File data source window. This seems like a live link is established as part of the connection process. How does the file name (versus the named range) play into what R&R can _see_? Is the SQL report designer looking for a new range name or a new file name in order to substitute another master table?____On a somewhat related note, when I create ANY new SQL report, the Master Table window opens up and displays both the named range from the Excel file under the label <<System tables>> If I double click on the line labeled <<System tables>> I then see the current sheet name in quotes. In any case, I can access the data in the file using either procedure. Is one actually the _alias_ of the other?____Any hints would be appreciated...____I am still working out the kinks in this master table substituion as part of using a control file...______Thanks.____Mike P.__Buffalo _ NY__

Try putting each XLS in a separate directory and create a separate data source for each. Then you can open the report selecting the appropriate data source.__R&R does sometime get confused when there are multiple worksheet files in a directory.____Kathleen__R&R Support

__Actually, the original problem was not how to establish stand-alone data source connections to different data files in different folder locations. My problem relates to making substitutions of other data files (with a common record layout) using the SQL version of R&R.____Although I have been struggling with the concept of implementing ODBC data source connections as first time Version 10 user, I find the material in the Help Menu to be very limited. Is there any white paper available on the ODBC issue or perhaps what limitations there might be re-setting ODBC links using a control file?______Mike P.__Buffalo - NY__