Your code seems to be correct , what are the fields you are linking between this excel code and sql db? May be there could be something wrong in the linking field.What is the error message you are having?
Below my sample code works fine for me.
LOAD Office as OfficeID,
 as FY03,
 as FY04,
 as FY05,
 as FY06,
 as FY07
FROM Budget.xls (biff, header is line, embedded labels, table is Sheet1$);
The script loads and at the end I get a message: (dutch language)
When I translate it for you it tells that the execution of the script fails and then it asks if it should load the old data again.
The weird thing is, that I only get this message if I rename the field Costcenter to costcabroad
I use the costcabroad field above for other things and now I want to match them. The rest loads fine (contractgroupdate & data)
I've removed a circular reference but it still does not work. My full code: (as you can see I want to match/link the field costcabroad) What am I doing wrong?
IF(Trim(costcTemp)= '', '40000',costcTemp) as costcabroad,
KostenplaatsNummer as costcTemp,
LOAD Costcenter as costcabroad,
[1VG won] as [1VG],
[2VG won] as [2VG],
[3VG won] as [3VG],
[4VG won] as [4VG],
[5VG won] as [5VG],
[6VG won] as [6VG],
[7VG won] as [7VG],
[4LG won] as [4LG],
[7LG won] as [7LG],
[6GGZ_C won] as [6GGZ C]
(biff, embedded labels, table is dagen$);