I have a subroutine that runs on a local copy of a database and a network stored master. To allow users to run my Excel add-in offline, I create a local version that has the same table names as the …
Tag: excel
Vertical Filter in MS-Excel by color
Is there a way to (not hide) but filter, columns in excel instead of rows. This is a sample of data, it continues further. I need to be able to say filter only the red columns – display only the red …
How to export Excel data from different sheets to SQL-SERVER Database?
I am new in Excel VBA and SQL. I have managed to create a macro button and push Excel cell data to SQL server tables. However, I am a bit puzzled: How can I take Excel cell data from different sheets and then push them to different tables in SQL Server database? (Currently, I have 3 sheets – Customers, Test,
Excel VBA – Stored Procedure (SQL Server)
I have a slight issue retrieving multiple recordsets (with column names) and pasting the data into an Excel sheet, like the image below The VBA code that I have just retrieves the first recordset but …
SQL extract data to Excel using Powershell
I want to extract data from SQL server to a new excel file using powershell . For small data set my code works but some tables has more than 100.000 rows and this will take ages. The reason why I don’t use the utility in SQl server is because I want to extract mutilple tables. Is there a way to
Export one field from access to specific cell in excel
I want to place a name from a table/query to a specific cell from access. I have a check sheet with lots of data in other cells that at the top has the persons name at the top. I would like a button …
Access VBA Find Records using Search Critera in Recordset
I have an Access database connected to excel. I need to find records using Search criteria in recordset from Excel Table name in MS Access is MyTable with more than 10 columns with data User enters string data in Excel cell, let us assume Worksheets(“Sheet1”).Cells(1, 1) My need is, macro has to loop through any matching string in column7 and
ADODB Connection to two access database
Due to ms access 2GB limitations on space; i am considering splitting a database into two. However I regularly rely on SQL statements such as the following: Is there a way in ADODB to perform the above, ie INSERT INTO table in file 1, the SELECT data from a table in file 2 ? Answer Here’s an example of updating
Data type changing after multiplying two columns in MS Access
I want to multiply two columns with each other and use the following code CDbl(amount) * CDbl(weighting) AS [amount_weighted], “Amount” is a regular number while “weighting” is a value between 0 and …
import from excel to sql server: The ‘Microsoft.ACE.OLEDB.12.0’ provider error
I want to import data from excel to sql server, but I got error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. op: windows 10 64 bit excel: 32 bit There is no …