Skip to Content
0
Former Member
Jan 26, 2012 at 09:21 AM

Load data from Excel in PAS

24 Views

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.