I have an excel load. I would like to filter the data. The only problem is that the between function is not working. I get the following massage: garbage after statement. Could someone tell me what I am doing wrong.
With kind regards,
[Data Dump\JobCost\Jobcost.xls] (biff, embedded labels, table is [Sheet1$])
JOB_NUMBER <> '0' and BILL_CODE = '5.01' and JOB_NUMBER between '07D0000' and '12D8000'