>Thanks Cetin, For now I have worked around it by creating the import table before I import the records but I'll try you suggestion later when I have time to play around with it.

Then in your Automation code :

ActiveWorkBook.Rows(1).Delete && To remove header line

Cetin