how to get excel file from query in SQL automatically?(For Example Every 1 Hour in one Destination.)

Question

this is my data

select productid,productname from product

It depends on what database you use, what IDE you are using? Can you please tag the database — Jim Macaulay, Jul 28 '20 at 05:54
The question need more details like sql type, Operating system, etc — Chilarai, Jul 28 '20 at 05:59
This is typically provided by the SQL client software that you use to access your (undisclosed) database. — a_horse_with_no_name, Jul 28 '20 at 06:40

score 0 · Answer 1 · answered Jul 28 '20 at 05:56

0

If this is Microsoft SQL Server, you can use "sqlcmd" command line tool.

See example here

answered Jul 28 '20 at 05:56

K4M

1 Answers1