Combine two DB sources on one report

[smmt2207]

I have a SQL DB, that I currently am reporting off. Come to find out that there is one piece missing. the monthly financial accruals never get put into my financial db, but are just kept on an excel spreadsheet. Has anyone ever reported from two db sources on one report? Or, using excel or crystal is there a way to import the excel spreadsheet into the db without creating a monster?

Any input would be greatly appreciated.

 

[Turkbear]

Hi,
Combining 2 dissimilar datasources is possible but usually results in poor performance, even if you can get the joins to work..

Can you export the excel data into your DB? As an alternative, can you bring the DB data and the Excel data into Access?





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

 

[smmt2207]

I just asked our DBA if we could write to the DB and they said yes. We are going to give that a try. Thanks for the input