Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Reading from an excel spread sheet?
Go
New
Search
Notify
Tools
Reply
  
Reading from an excel spread sheet?
 Login/Join
 
Platinum Member
posted
I have data in an excel spread sheet that I need to read. Any ideas on how to set this up as a data source and read it.

Thanks.
 
Posts: 176 | Location: Desplaines | Registered: August 05, 2004Reply With QuoteReport This Post
<Vipul>
posted
These are the steps:
1. Step 1: Create an ODBC Data Source
Creating an ODBC DataSource under Windows 2000
Goto Start -> Settings->Control Panel -> Administrative tools -> Data Sources (ODBC)
Under the System DSN tab, click on ADD.
Select Microsoft Excel Driver
Type in a name for your Data Source
Click 'Select Workbook' and path to your Excel file.
Step 2. Configure WebFOCUS 5.2.x for Excel

Edit file EDASERVE.CFG (i.e. drive:ibi\srv52\wfs\bin\EDASERVE.CFG) and add the following line:
odbc_access = y

Edit file EDASPROF.PRF (i.e. drive:\ibi\srv52\wfs\etc\EDASPROF.PRF) and add the following lines:

ENGINE SQLODBC SET CONNECTION_ATTRIBUTES data source name/,

Step 3. Create a Synonym to Access the Data in WebFOCUS


Vipul
 
Reply With QuoteReport This Post
Expert
posted Hide Post
How to Access Data from an Excel Spreadsheet via WebFOCUS
Abstract: This document discusses how to access data from an Excel spreadsheet via WebFOCUS.
http://techsupport.informationbuilders.com/tech/wbf/wbf_tcn_068.html
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
I want to take a step back and ask a question here...Is this a one time read of a spreadsheet or will you want to be able to change the spreadsheet on a regular basis. While the above ways will support either, if you are just reading a static spreadsheet that you don't change, there may be an easier way to read the spreadsheet. For example, if you just have a list of one column that never changes, you can FILEDEF to a txt version of the spreadsheet. If you have a one time read of more columns, you might find it easier to FILEDEF to it and build an MFD for it. Guess I need more info to answer this one.

Stan
 
Posts: 90 | Registered: April 15, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Reading from an excel spread sheet?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.