Hi,

Can anyone help me how to create the master file from a excel sheet in webfocus 7.6 windows enviornment. I am able to create a master file from csv, but unable to create from excel sheet (xls).

This message has been edited. Last edited by: <Kathryn Henning>,

If I remember correctly, in 7.6 you need ODBC and define a range on the XL sheet.

how to proceed with the ODBC connection ? Can you tell me the procedure it could help in better way

Check below link for configuration procedure.

http://infocenter.informationb...ource%2Fdbsqlexc.htm

Hope this helps.

Pooja,

Control Panel\All Control Panel Items\Administrative Tools
System DSN
Add
Microsoft Excel drive
Choose EXCEL sheet
!! Remember your EXCEL must have fieldnames in first line and a named range must be defined !!
Then create the master using ODBC interface of WF.
Good luck!