Uderc programming article aggregator sites
Index -> powershell sql query to excel

powershell sql query to excel

Advertisement

Oracle SQL Query from EXCEL 2007 with prompt

Hello, I have many excel reports where I am pulling information from our Oracle 9 db through Excel using the following method: http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/ http://blog.mclaughlinsoftware.com/

Problem with SQL Query in Excel VBA

I am trying to retrieve data from a SQL table using Excel VBA.  The query will only return data from the first field in the query.  this is the code I am using: objGroupConn.Open Set objGroupCmd.ActiveConnection = objGroupConn objGroupCmd.CommandText

App-V Reporting: SQL query for Excel Pivot Table to display App Usage (H/M/S)

I recently posted this in the Gallery.  If anyone has any modifications or enhancements please feel free to contribute!  One thing that I'd like to be able to add to it is the ability to only display information for applications/packages that are sti

Change the way information is displayed from SQL query in Excel

Hi, I'm trying to set up a spreadsheet that displays information directly from our SQL database using the Microsoft Query Wizard.  I have a very basic understanding on how to do this, so I can create a spreadsheet that gives me most of the informatio

Powershell sql query connection remote forest

i need to make connection to the sql  server which is in different forest for which i have creds how do i make connection to remote sql server and query the database  (remote sql server = sql24567-000.outerspace.net) $SQLServer = 'SQL87630004-002.inn

[Excel] Running a SQL Query to delete rows

Hello Experts, Background: I am attempting to use a dba of my companies time keeping system and implement it with Power BI tools. Given the file size restrictions within Power Bi itself I need to lower my file size by removing all time logs from inac

Using Powershell Script Run simple query in MS Access 2007 and export the results of query to Excel

Hi Experts, I have a Access 2007 DB file and 2 Big tables inside that (bigger than the size that can be easily handled by MS Excel 2007). My requirement is automate using powershell scripts the below things. 1. Create a SQL query in Access DB and sa

Export to Excel from Report region (pl/sql returning sql query)

Hello all, I have encountered an interesting problem. I have an HTMLDB application with a lot of sql reports coded straight inside the report region. In order to better organize my reports, I decided to 1. make all my report regions of type "Pl/Sql f

Report from SQL Query -Excel format only show the first page

Hi, I have some Reports from SQL Query. In the display options, I choose Excel as default format. The Excel documents only show the first page. If I choose HTML as default format, it shows every rows. Please advise on how to have a complete Excel doc

SQL query in powershell Errors on IIF

Hello, I have put together a Powershell script from examples online to run a SQL query.  The query came from Access and it seems Powershell has a problem with the syntax. I'm pretty new to scripting and adding SQL to the equation isn't helping. Power

End the result of an sql query by Email as an excel file attachement

Hi, I would like to create a PL/SQL function that send the result of an sql query by Email as an excel file attachement. i'm newbie in pl/sql an d i dont know if it's possible to do such task. regards,i think a regular expression is he way to go in y

Power Query for Excel - Need Help with Oracle SQL Syntax

Hello everyone, I am new to Power Query and am not able to figure this out.  I am trying to pull in data into my Excel spreadsheet using a specific Oracle SQL query.  While in query editor, how do I take the Oracle.Database function and add my SQL st

Repair Problem with Excel Removing All But First External SQL Query Tables

We have an Excel 2007 XLSX workbook that we created for doing some business analysis from the SQL database that contains data from our MRP system. It started as a single sheet with one data connection running a SQL query. The data comes into the spre

Need sql query to import from excel sheet

Hey , i need sql query to import from excel sheet. i work in a company where i need to daily update the data from excel sheet. if i get a shortcut method i ill be very thank full to you guys to reduce my work upto 10 %.any query which can inert from

Require Code which export SQL Query resuluts to excel using checkbox option

Hi All, I need a sample code which can export the SQL Query results directly to an excel file using checkbox option. for example if I select checkbox1 and press a save button, then on backend SQL Query will execute and save the results in a excel fil

Need SQL Query which saves query results to an excel file

Hi, I am looking for a sql query which saves/ export results of an query to a excel file Thanks, ChetanI am looking for a sql query which saves/ export results of an query to a excel file Thanks, Chetan Options: 1) You can use BCP command to export r

Excel ADODB Sql Query Execution taking hours when manipulate excel tables

Hello All  I have 28000 records with 8 column in an sheet. When I convert the sheet into ADODB database and copy to new excel using below code it is executing in less than a min Set Tables_conn_obj = New ADODB.Connection Tables_conn_str = "Provider=M

Excel ADODB Sql Query Execution taking hours when manipulate excel tables why?

I have 28000 records with 8 column in an sheet. When I convert the sheet into ADODB database and copy to new excel using below code it is executing in less than a min Set Tables_conn_obj = New ADODB.Connection Tables_conn_str = "Provider=Microsoft.AC

CrystalRpts - Excel Data source, SQLServer2005 table. SQL Query behavior?

Greetings - What should be a simple report (with Excel 2007 spreadsheet as primary data source linking to a SQLServer 2005 table ) returns incorrect results.  Query designed to select data from SQL Table with  'DATES >=' certain date, but data return

Email SQL query results from powershell

I currently have a script that I run every half hour which runs an sql query, and takes the results, and emails them to a group of users.  The script states how many faxes are in a faxmaker queue.  Now, the powers that be would like to add additional