Hi,
Every day I'm receiving a new excel file containing yesterdays transactions. Now that the files are piling up, a regular reload is staring to get pretty time consuming. I've been looking at quite a lot of tutorials but I'm still pretty much clueless of how to solve my particular case. Any ideas?
Thanks in advance,
Olle
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
//INCOMING
ColumnHeader:
LOAD
Reference,
Type,
SettlementAmount,
Time15,
Time30
FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Incoming);
//OUTGOING
Directory;
Add LOAD
Reference,
Type,
SettlementAmount,
Time15,
Time30
FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Outgoing);
