Import Excel Spreadsheet Data

[metalteck]

I currently have a crystal report that returns account numbers and shipping information I need. I also have a spreadsheet that contains a list of account numbers. I need to take all of the account #s in the spreadsheet and put it into the crystal report, so that I can get all of the necessary information. I've imported the spreadsheet into an access database, but I'm stuck here. I add the database to the exisiting crystal report.

Do you have any suggestions on how I can accomplish this.
I'm using Crystal 8.5.

 

[synapsevampire]

I currently have a crystal report that returns account numbers and shipping information I need.", so why not share the source of these account numbers?

Show example data an expected output for better results.

-k

 

[metalteck]

Currently, when I run the Crystal Report, it generates, account#, address, name, city, state, zip, phone#, email address.
ex:

77789 Mac Joe Miami Fl 33023 3051234568 joe@joe.com

the spreadsheet currently has just a list of accounts and consumer demographic information. EX:
Acct# Age Sex Race Preferance
112345 28 Male Hispanic None

Based on the information given on the spreadsheet, I want to generate a report based on all of the account numbers on the spreadsheet and add it to the exisiting Crystal Report and get all of the shipping information to be added to the demographic information.

The only way I can think of doing this was by importing the spreadsheet into a MS access database into a table called Demographics. Now when I want to add the demographic table to the exisiting reports, I'm getting an unable to read library error.

Help Please

 

[synapsevampire]

You haven'tidentified how one relatesto the other which fields?

-k

 

[metalteck]

Currently, when I run the Crystal Report to get all of the shipping information it based on the badplpp table. This table contains all of the fields such as account#, name, address, city, state, zip, phone#, and email address.

I want the data in the spreadsheet to pull information from the badplpp table. The common field is the account# field. So when I pull the the new crystal report, it will have all the information that was in the exisiting crystal report along with the information in the spreadsheet.

 

[metalteck]

Hello? Did you need any more information?

 

[francesguan]

Hi,

I have an excel file,which used to collect material shortage information, several people from differenct workstation need to enter into this spreadsheet.

I also want other group people, like purchasing, can read this report.

but if one person open this Excel report,even in idle time, other people could only open a read version.

then, I tried to use crystal report to read this report, and hope when other people read from crystal report, at least one person still can enter into the excel file. however, whenever I open the cystal report, other people can only open a read only version.

any idea to share the spreadsheet with other people?


thanks in advance,
Frances

 

[dgillz]

Frances,

You need to start a new thread.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry