When importing data into Excel via SQL query integrated into VBA code - how do I just import the data - without the header columns?
When I run the query to pull 1 row off an access database it is returning the coumn headers for each row - which is pretty annoying.
There doesn't seem to be any help on the almight google!
Your collective genius will be most greatly appreciated.
Thanks in advance!
Max
p.s. this post is also up in the Excell Help forum. Wasn't too sure where to post this!