MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How do I export an SQL Query to Excel? [Help please!]
3665
Alex Bake
August 11, 2011 04:16AM
Re: How do I export an SQL Query to Excel? [Help please!]
1347
Barry Galbraith
August 11, 2011 04:17PM
Re: How do I export an SQL Query to Excel? [Help please!]
1262
Rick James
August 13, 2011 03:22PM
Re: How do I export an SQL Query to Excel? [Help please!]
1340
Erik Haselhofer
August 17, 2011 06:30PM
Re: How do I export an SQL Query to Excel? [Help please!]
1227
john martin
August 17, 2011 11:43PM
Re: How do I export an SQL Query to Excel? [Help please!]
1728
hetaltbs dodiez
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.