Load data from Excel in PAS

[Former Member]

Hello,

I'm trying to load data into PAS with this procedure:

CLEAR STATUS

SET PERIOD monthly

SET PERIOD JAN12 - DEC12

sel var INDFINAN1_ACT, INDFINAN1_TAR, INDFINAN2_ACT, INDFINAN2_TAR, INDFINAN3_ACT, INDFINAN3_TAR, INDFINAN4_ACT, INDFINAN4_TAR, INDFINAN5_ACT, INDFINAN5_TAR, INDFINAN6_ACT, INDFINAN6_TAR, INDFINAN7_ACT, INDFINAN7_TAR, INDFINAN8_ACT, INDFINAN8_TAR

ACROSS TIME DOWN VARIABLES

ACCESS LSLINK

CONNECT Excel_ext

BEGIN

SELECT * FROM KPI_FINAN

END

PEEK 20

READ

END

But it displays the message

"ACC001: There is NO Corresponding Field for VARIABLES. "

Please, can anyone tell me what is wrong?

Thank you in advance.

Gorka.

[Former Member]

Good morning!

I have seen the ligth, finally the problem came from the Excel file, in the column of the variables filled in this file, the word that was missing was "VARIABLES". Now the problem is solved!

Thanks anyway.

[Former Member]

HI Gorka,

     Can u fwd me the Excel sheet, because i am not getting anything from the code. Also need the excel file for refrence.

Will be thank you.

Max.

[Former Member]

Hi Maxban,

It is too late, but if the file can help anybody here you have.

Regards,

Gorka.

Sorry, I can not attach an excel file, so I upload one photo.

VARIABLES	JAN12
INDFINAN1_ACT	43,52
INDFINAN1_TAR	45
INDFINAN2_ACT	95000
INDFINAN2_TAR	100000