sql excel

Hello Everybody, I am myself an excel VBA programmer as well as programmer in other languages i.e. Java, JavaScript, Python and C++. Currently I got a project where I have a huge dataset (more than 20,000 records spread over 25 columns) and not only that I have to search each record, I have to...

Hi! I'm running Office365 package Excel 2016 with MS Query to DB2 SQL database with the query being parameterized towards a specific Excel cell value (although I need to populate this cell from a larger range first). While SQL clauses work fine when cell has a single value, I need to run SQL IN...

Hi Folks, I've got an issue trying to figure out how to loop across horizontal parameters for multiple iterations. My requirement is to build a report that sums revenue by week for only the first 13 weeks period for any customers that started on or after 2018-01-01. I have a simply msquery...

Greetings Folks, I'm probably not in the right area but I have an idea that will make my job and the job of my peers 100000x's easier. I was considering sitting down and redoing all the letters we send customers using UserForms or using Excel, somehow and googling until I figured out how to...

<colgroup><col span="5"></colgroup><tbody> <colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody> I need to split data, i am having 24 hours data. the time interval also included in that columns. for example, input...

Background: I created a SQL query as follows. Exact Query SELECT `CLog$`.CID, `CLog$`.OpenDt, `CLog$`.CloseDt, `CLog$`.AID, `CLog$`.Trader, `CLog$`.Strategy, `CLog$`.Security, `CLog$`.PnL, `CLog$`.DaysHeld, `CLog$`.NotesFROM `CLog$` `CLog$` WHERE (`CLog$`.OpenDt>=? And `CLog$`.OpenDt<=?) OR...

I am trying to run a query in excel where I can use a column from a different sheet to pull the data I need. In excel I run a query and pull the follow fields (plus some): <tbody> Account Number Effective Date System Next Pmt Date Payment Amt 123456 2/17/2017 IVR 3/13/2017 $200.43 254684...

Hi I'm doing simple connection to MS SQL and want to get count and display into excel: Sub test() Dim conn As ADODB.Connection Dim rcrds As ADODB.Recordset Dim iRowNo, i As Long Dim id, name, value As String Dim wb As Workbook Dim ws As Worksheet Set wb =...

Hi, I'm currently building an MI report in MS Excel from a MS access database, everything was working fine and then all of a sudden I start getting the following error: 'Wrong number of arguments or invalid property assignment' Nothing has changed in the query I'm running. Below is a little...

Hello We have a SQL database in Azure setup but we can't connect to the tables in Excel 2007. We're selecting Data, From Other Sources, then From SQL Server and enter the server address / port alongside the relevant username and password. We can see the database "HS" in the database...

Hello! I have a XML file exported from a SQL database that looks like this when imported to excel: I need some way to make it look like this: (I thought the best way to explain it was with images) There is a lot of data, can anyone help me with a function to do this? I already tried with...