Skip to Content
0
Former Member
Sep 14, 2007 at 08:56 AM

Excel as the data source

30 Views

Post Author: Bobby

CA Forum: Data Connectivity and SQL

I guys, I have a question on u2018Crystal Excelsioru2019.

I want to know whether we can connect a excel spreadsheet with several sheets that lives on a remote file server to crystal excelsior to act as the data source. Crystal excelsior would then be used on the client pc, connect to the excel and create subsequent reports from the data?

Basically I have an excel sheet that conatins several excel sheets. Each sheet contains various information that have relationships with each other. I want to know whether it is possible for the excel to sit on a file server and act as the data source for Excelsior. Excelsior would then be used on the client. I can also upload the excel onto a web server if that will make things easier.

Cheers

bob