Export to Excel - How do you ignore Column Headers?

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\MSSQL\;HDR=Yes;', 'SELECT * FROM Test.txt')

SELECT * FROM Keywords

True this is for iimporting data ... but use HDR=No; It might be worth a quick test

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks Ron.

I was doing it a little differently.

I do not see a property on my Excel Connection where I can set the Header to False.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I started a new post because the way I worded it was not the best for a reply.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/