Using append from Excel will Import all the rows of Excel. you will have to delete the Header Row Appended. For NULL columns you may check out NVL() or ISNULL() functions.




>Hil,
>
>I'm using appendfromexcel() to import an Excel spreadsheet, but it's taking the first row and stuffing it into the header in the sql cursor, and then eventually loses it in the final output. It also strips off the first column, likely because it's empty, but that's the way I get it. At least with the native append from xl8 command, I didn't have these issues.
>
>Any ideas?
>
>Luke