Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

EXCEL Spreadsheet as DataSource for Crystal Reports XI

Posted on 2011-02-18
1
439 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 100

Accepted Solution

by:
mlmcc earned 500 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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 article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
A short article about problems I had with the new location API and permissions in Marshmallow
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

839 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