Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have a problem. I have to load an weird excel file in which the column A has got some unique ID codes (either 2 digits or 7 digits).
Is there a way to load only the rows that have got 7 digits?????? (or to ignore the lines with 2digit ID)
Thank you in advance and wishing you a happy new year
Load * From
FileName
Where Len(ID) = 7;
Thank you very much. quick answer and spot on !!!