Hey Evebody,

I new for here and my english is not so well... sorry for this.


I'm new with webfocus and I'm trying to create synonym command, like this:

CREATE SYNONYM test_tbExcel FOR Presencial WORKSHEET DIREXCEL AT tb1.xls
END
-RUN



Anybody knows how the correct command for this?


Kind Regards.

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

In my attempts, I got this code:
-*CREATE SYNONYM [app name]/[new synonym] FOR [target table] DBMS [dbms type i.e. SQLMSS] AT [adapter name]
CREATE SYNONYM ino_dmiranda/presencial2
FOR E:\ibi\apps\ino_dmiranda\2008_01_sem.xls\Presencial DBMS DIREXCEL AT EXCEL
END
-RUN


However, is taking place the following error message:
(FOC31041) DIREXCEL CRSYN PRESENCIAL2: worksheet is empty

Hi Diogo,

Welcome to Focal Point!

Which release of WebFOCUS are you using? Would you please update your profile with this information?

When reading from Excel data, you can use the Adapter for Excel (via Direct Retrieval) or ODBC. The following document, while old, should hopefully give you an idea of where to start if you're using ODBC:

How to Access Data from an Excel Spreadsheet via WebFOCUS

I searched through the forums and found topics discussing reading Excel data with WebFOCUS, and you may find one more specific to your environment.

Regards,

Kathryn

Hi Diogo,

The syntax is incorrect, try -

CREATE SYNONYM ino_dmiranda/presencial2
   FOR ino_dmiranda/2008_01_sem.xls
   DBMS DIREXCEL
   PARMS 'WORKSHEET Presencial'

T

This document will give you the information -
Adapter for Excel (via Direct Retrieval)
You will need to sign on to techsupport.

T