Excel Friends,
I have been trying to develop a recordset update VBA code for a customer SQL server database. I could develop a "rs.addNew" record easily. However, I do not know SQL/VBA enough to make the update code below work for me. This Sub is called after another sub that actually makes it...
Hi,
I am trying to edit the code from below mentioned website to suite my requirements.
However, before I could finish editing, I could see few of the code lines are reflecting in red.
I have mentioned 'Code is reflecting in red line below' just above the problematic code.
Can anyone please...
I'm connecting to Access and opening a recordset for data which should match my Worksheet.
Is there a way to check each Excel row against the recordset, without looping through every column?
(They're in the same order on both).
Does anyone have on hand a iterative method to print a recordset to the immediate window. Preferably all columns and rows in a table manner with the field names at the top.
Using remote Automation from MS Access, the ObjXL is just an object reference.
A recordset (using copy from recordset) inserts data at cell A6. The Recordcount is known.
The recordcount variable is used to set the range to match the number of records returned.
There are 15 columns midway - if an...
I am trying to pass a recordset to an HTML javascript. The reason is that my company's web page sercurity policy does not allow me to create an "ActiveXObject" in javascript. I was experimenting with passing a recordset from VBA to HTML javascript function as a work around. I can't seem to...
I regularly run queries inside excel VBA.
What I do is I store the SQL code in a String variable 'sqlStr', and then I use that string and pass it to a function which runs SQL Code by opening a connection with ADODB, connecting to a 'serverName' and 'databaseName'...
there are hundreds of...
I am getting "Run-time error '-2147287038'(80030002)" when the code getting to populating the recordset. I can always fall back on embedded SQL, but want to introduce my team to faster techniques.
What I thought of trying was to open the connection, the use QueryTable.Add to bypass the...
I have been beating my head against the wall on this one for a couple of days. :banghead:
I'm trying to get a recordset from SQL based on a query using ADO, replace all but the first four fields of the single record, and write it back to a table in SQL. I can read the recordset from SQL and I...
I have a program that requires a weekly update. Excel is used as a front end application and Access is used to house the data. The people running this do not have Access but need to upload the data into it. Currrently I'm going row by row to upload the data and it's taking longer than I think...
I have an Oracle table query that the resulting Recordset could be used in three further queries. Is there a way to reference the first Recordset in another query that also pulls data from Oracle tables.
Example:
Dim Cmd1, Cmd2 As ADODB.Command
Set Cmd1 = New ADODB.Command
Set...
I have an Excel list which has a computer name field in column A and in Column B, C, D and beyond in each column it list a single specialist application name. Many Computer names do not have any specialist apps so there is nothing in B, C, D and some computer names have up to 12 or more...
Hello,
I have a userform on excel that connects to ms access DB, i have developed the code to display,movenext and update records but i have an issue when i try to move to the next record with SQL query that filters records.
ex: SQLquery= select * from table1 where test1='unique' --- then i do...
Bit of a long-shot on here, granted, but I wonder whether anyone could give me some generic advice. I have a sharepoint list with about 50k records (I know this has busted the recommended capacity by a considerable degree!), and I have linked this list in MS Access 2003. Now, this list has...
I load the recordset with this qry which is strsql in the vba below
select
' ' as UltimateParent, .....etc etc from.....
Then once the field UltimateParent is in the recordset and it is open I try to modify it like this:
Set Rs1(RsLevel, RsIndex) = New ADODB.Recordset
With Rs1(RsLevel...
Hi All. I currently have a workbook that has VBA functions that calculates values by looping through large amounts of data in a few large excel sheets. I want to transfer the data from these sheets into Access and then bring data into the VBA code via an array from the data in Access rather than...
Hi all
I really hope someone can help me because I am stuck. I am using 32-bit Excel 2010 on a 64-bit Windows 8 i7 8GB machine. This means I only have <2GB of ram for Excel to play with.
I have a workbook that imports data from another workbook using the ADODB.Recordset/Connection model. This...
I am having trouble setting up a query for a recordset that will list duplicates for an automated process to clean up. I am using Excel 2010 with Microsoft ActiveX Data Objects Recordset 6.0 Library and Microsoft ActiveX Data Objects 6.1 Library as references.
So far, I have chopped the query...
Hi All-
I have a problem I hope someone can help me with. In a nutshell, I'm trying to use data in an existing table (table1) to "look up" data in another table (table2) and summarize the data from table2 in table1. Here is an example:
table1:
<tbody>
LoadDate
FundName
NAV
3/8/13
HY-EUR...
Howdy How
Just getting into more SQL heavy orientated stuff to work things a bit smarter and faster when I then start vba/excel'ing with my recordset
The datatype on the server (PL/SQL Oracle), like a lot of them, is in text format
so after reading up on the CAST function, I can successfully...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.