Solved

Excel Import

Posted on 2003-10-27
4
233 Views
Last Modified: 2012-06-27
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
Comment
Question by:cossy74
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 9632562
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
 

Author Comment

by:cossy74
ID: 9636952
Peter57r: How do i ensure my data set is as a table?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9637125
It just has to be in consistent rows and columns with column headings.  No empty rows and no empty columns.

Pete
0
 

Author Comment

by:cossy74
ID: 9682847
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
Speed Up Crystal Report 5 61
Crystal reports Cross Tab - Display dates even if no data returned. 20 124
Crystal Reports - group header 2 48
Sum not calculating correctly 22 39
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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