• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Excel Import

Hi,

I am wish to find a way to create a excel file that i can use in crystal 8.5.

Currently i have create an excel file and save it.

I created a data source using the Microsoft Excel Driver (*.xls) and selecting the excel file.

When i go to use the data source (either thru MSQry or Crystal ) i get an error saying no visible tables are present.

What is going wrong?
0
cossy74
Asked:
cossy74
  • 2
  • 2
1 Solution
 
peter57rCommented:
Make sure you have your data set out as a table.

Then follow these instructiions:

http://support.crystaldecisions.com/library/kbase/articles/c2010002.asp


There are lots of possible issues in using Excel as data source.  Hope for the best.

Pete
0
 
cossy74Author Commented:
Peter57r: How do i ensure my data set is as a table?
0
 
peter57rCommented:
It just has to be in consistent rows and columns with column headings.  No empty rows and no empty columns.

Pete
0
 
cossy74Author Commented:
It seems that the default for a worksheet is a system table. There need to include system tables in the options.
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.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now