CALENDAR MALFUNCTION

[#1]

hello, i have not had too much trouble with my calendars before, but i continue to get errors with this file. it says the templcalendar table cannot be found so then the rest does not work. any ideas?

thanks for the help,

Parrish

[simospa]

Hi Parrish,

did you try to run the script in debug mode, so you can see step by step  the reload process?

S.

PS: otherwise try to post a sample of two xls files you are using (CALENDAR.xlsx and SHIPMENT FILE.xlsm)

[#3]

it looks like i was just overlooking the fact that i had not entered "MAPPING" infront of load...thank you though!

[MK_QSL]

1) you are missing Mapping Keyword in DATEMAP table...

so when you are using

Applymap('DATEMAP',[Period/yr],0) as Period_Date

you are not getting any Period_Date...

Try below and load again

DATEMAP:

MAPPING LOAD [Period/yr],

     Period_Date

FROM

(ooxml, embedded labels, table is Calendar);