ssmith266
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: SQL Table into Excel File
Thank you for the reply Robin, fortunately I was able to work through the issue. Your approach is correct - In the picture below I have a Netezza DB (JDBC Execute Snap) Table that I am select everything from, an excel formatter snap and a file writer snap. .3.8KViews0likes0CommentsSQL Table into Excel File
I have a pipeline that I am working on that requires data to be extracted and transformed in SQL Server (completed) and should be loaded into a single excel file. I cant seem to get my data into an excel file. Has anyone completed a similar load, if so, how? What snaps and order did you use? In my research I have seen a lot of articles about excel to DB but not the other way around.Solved