Use 2 Excel files to create 1 report

[kridg]

Is there any way to use 2 (or more) separate Excel (.xls) files to create 1 Crystal Report Version 8 report?

The main Excel file "Projects" contains a column with an identifier for each row;
The second (and other) Excel files have a similar column that contains the same project identifier. These additional Excel files are the updates from each of the managers on the specific projects under their control.

I want to create a report that shows all pending jobs in "Projects", and also includes the project updates updates from the additional Excel files.

Excel 2000
Crystal Reports Version 8

Thanks, any help is appriciated!

 

[FoxG]

Any number of files saved as csv files can be linked using the ODBC link Microsoft Text Driver provided that they are in the same directory. This can be specified in the configuration of the ODBC link (usually Text)

More than one directory may be catered for by defining more than one ODBC link to the Microsoft Text Driver

Either export the excel files to CSV or alternatively you may be able to do the same thing straight from the Microsoft Excel Driver ODBC link from within Crystal.

The first line in the Excel file must contain the field names for the table!

We use Crystal Reports 7 and this work fine here.

Geoff

PS. This is the 3rd question similar to this.
I may need to set up a FAQ!!

 

[kenhamady]

To report on a spreadsheet, you should name a range in the spreasheet, which will become the table name. Call this range anything but TABLE, which is one of the other reserved words. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.