I am trying to export data from RE to use in a Crystal Report and a RE Custom Report.  I can export the data I want in Excel format and it works fine but when I change the Export Options to use Access or MDB format, although all Output fields are identical, I have problems.  I'm trying to export a list of fund contacts with 4 phone types: Home, Business, Cell phone, and Email.  I've set the Output to include All Addresses -> Phones ->Phone type -> Phone number.  The Criteria for Phones is # of phones to export: 4    When I preview it or export it in Excel, each contact has all four phone types with the corresponding phone number.  In Access or MDB, Contact #1 gets his own home number, Contact #2 gets Contact #1's business number, Contact #3 gets Contact #1's cell phone number, etc. 

Does anyone have any ideas?  If I use Custom Reports, the Export format of Excel is not an option - only Access or MDB.

Thanks for your help-

An excel file and an .mdb (access) file are vastly different.  An .mdb file is a series of related tables (a relational database) and excel is a simple flat file.  An .mdb file is the better, more accurate way to go as you will find limitations and get incorrect results with using excel in crystal reports which is why RE limits the custom reports to those options.

You will need to re-design your report to work with an.mdb export file.