Creating query by reading records from an excel sheet

[PDAnalyst]

Hi,

I am using CR 11R2 on a Windows XP SP3 machine, querying against a MS SQL Database. What I am trying to achieve is if there is a way for the query to be formed by reading an external excel spreadsheet.

I have other users that are adding names to an excel spreadsheet for their future use and I need to query these names periodically from our Records Management System to see if we had any new contacts. Instead of typing the names as well as adding new names as they add to the spreadsheet, I am trying to find out if I can have the query statement to "read" from this excel spreadsheet and build the names query.

Any help is appreciated.

Thanks

Safa

 

[Turkbear]

Hi,
You can try creating a report using the Excel sheet as the datasouce and insert a subreport to access the data about each name from your main database..

You could even try to join the 2 tables,(Excel LEFTOUTER--> MSSQL) but the type differences between the sources could make that not an option.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[PDAnalyst]

Thanks,

will give that one a try and report back.

I appreciate it,

Safa