Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

EXCEL Spreadsheet as DataSource for Crystal Reports XI

Posted on 2011-02-18
1
Medium Priority
?
446 Views
Last Modified: 2012-05-11
An Excel spreadsheet is being created that I want to use as a Datasource in Crystal.  I was able to create a DAO connection using EXCEL 8.0.  I'd like to know if there is a better way to do this.  Can I create an ODBC connection from the Excel spreadsheet instead? Do I need to register a DLL first.  Help, please!!!
0
Comment
Question by:chaverly
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 34927392
If you have an ODBC Excel driver, you probably can use it.

I have built them for simple reports and always just used the Access/Excel connection method which I believe is DAO.

mlmcc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Six Sigma Control Plans
Starting up a Project

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question