i want to load a table. I don´t need the 1st row, because in the 2nd row are the columnames.
How can i load the table, that the 1st row will be ignored?
Try something like :
LOAD * FROM [YourFile]
WHERE RecNo() > 1;
If you're loading from a file try use:
(ooxml, embedded labels, header is 1 lines, table is XXX);
Perfect, thanks a lot! @bill.markham, too :-)
Retrieving data ...