I want to link more than one column from an Excel sheet to a sql db. I've managed to link one column but when I load the second field and rename it the script stops loading and give a script error. My code so far:
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$);
The troubles begin with the field Costcenter. When I load it without renaming it, it loads without an error. I have to rename it to make it link to the field costcabroad from the sql db but the the script stops loading.
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.
CROSSTABLE(BudYear, BudAmount) 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$);