Export a Table or Query results from SQL Server to Excel

Export a Table or Query results from SQL Server to Excel

#SQLwithManoj #SQLServer #MSExcel #ExcelSQL

[nishsh]

Thanks for exploring both options in data dumping - all records as well as specific query records ...nice video !!

[zesar]

Thank you for showing both methods!!! 2nd method worked like a charm.

[mohitpande]

it solved my problem thank you so much

[kenyondailey]

Thank you for this explanation. Very informative and well done.

[somidixit]

Is there a way to use the query to pull the data from the table, when the table name changes and there fore output needs to refreshed depending on the table being selected ? Passing the table name as parameter via excel?

[octaviodiazkoch]

hi manoj it's a pleasure!
i'm having some problems to export excels files upper to excel 97-2003 versions, due the ace.oledb files, can you help me to solve this issue in my sql, would be preatty helpfull to me.
thank you.

[HappySingh-iqjx]

Manoj sir is it similar way to import also?

[Kbrebeau]

Thank you, How can you turn this into a job that runs every 2 weeks?

[ahsanmalik]

if we want to add some data in employee table ... will it automatically be store in excel file.??
and my 2nd question is that what is the procedure to make a xml file instead of excel file .. or we can save this excel file as xml file.?? i am waiting your answer ... thank you

[ASHOK_]

When I am following your steps I am getting the Error: “The Microsoft.ACE.OLEDB.15.0 provider is not registered on the local machine. (System.Data)

[suryasanjay]

Hi, can you suggest if there is a way to do this programmatically using c# code ? . I tried using data tables and sets but export is taking time. If data is huge fetching data from MSSQL is also costlier.

[anantghorpade]

excillent sir i tried but only headers of the colums copied can guide me please



Reply