Excel latest sheet from a workbook

[vardhancse]

Hi,

I have got one requirement,

I have one excel work book with approx 15 sheets.

as part of initial load, have loaded all the excel sheet using OBBC connection.

Now the requirement is that from the next reload I need to load the recent sheet and append to the existing table.

can any one please let me know the options to achieve the same

[vinieme12]

do your sheet name's provide any clue as to which one is the most recent sheet? for example a number or date value??

[vardhancse]

Hi Yes, sheet names will be in the format of J'AN 2017 Breaks' & 'Feb 2017 Breaks'....

[vinieme12]

can you post some sample to work with?

[prieper]

you may refer to the excel-workbook with ODBC-connection.

SQLTABLES will give you the workbooks.

You may check the returned names and decide programmatically, which is the last one (IF WILDMATCH(Table, '*DEC*') THEN .....)

HTH Peter