Excel Import

cossy74
cossy74 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

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

Pete

Author

Commented:
It seems that the default for a worksheet is a system table. There need to include system tables in the options.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial