MySQL Forums
Forum List  »  MySQL for Excel

Re: How do I export an SQL Query to Excel? [Help please!]
Posted by: hetaltbs dodiez
Date: August 18, 2011 05:50AM

Create an Excel file named testing having the headers same as that of table columns and use these queries

1 Export data to existing EXCEL file from SQL Server table

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [SheetName$]') select * from SQLServerTable

outsource seo services
seo reseller plans

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How do I export an SQL Query to Excel? [Help please!]
1688
August 18, 2011 05:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.