Excel Query in VBA without Column Headers

[zhb12810]

Hi, Not sure if this is in the right place but.......

I just wondered if its possible that when you run a query via VBA you can omit the columns headers and return the query into the specified cell.

Any help would be appreciated

Many Thanks

[Richard Buttrey]

Hi,

Just checked one of mine and the syntax is the .TextFileStartRow
i.e.

Please Login or Register  to view this content.

[zhb12810]

Thanks for that but it doesn't seem to work. I'm actually pulling the data from a DBF file if that makes any difference

Thanks again

[Richard Buttrey]

Might be worth while googling to see if there's an equivalent of the .TextFilesStartRow syntax.

You could always add a line of code

Range("myimportdata").cells(1,1).EntireRow.Delete

[zhb12810]

I've found that

Please Login or Register  to view this content.

sorts the problem

Thanks