BY CATEGORY
VBA CATEGORIES
VBA - WORKING WITH DATA VIDEOS
- Excel VBA Part 30 - Querying a Database with ADO
- Excel VBA Part 31 - Modifying Data with ADO Recordsets
- Excel VBA Part 32 - Executing SQL Commands with ADO
- Excel VBA Part 56.1 - Connect to SQL Server using ADO
- Excel VBA Part 56.2 - Get Data from SQL Server with ADO Recordsets
- Excel VBA Part 56.3 - Read and Execute SQL Query Files
- Excel VBA Part 56.4 - Return Multiple Result Sets from SQL Queries
- Excel VBA Part 56.5 - Basic ADO Commands with SQL Server
- Excel VBA Part 56.6 - ADO Commands and Parameters
- Excel VBA Part 56.7 - ADO Commands and Stored Procedures
VBA - working with data videos | Excel VBA Part 31 - Modifying Data with ADO Recordsets
Posted by Andrew Gould on 01 April 2014
How to use VBA macros to amend records in SQL Server and Access tables
You can increase the size of the video:
You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.
You can also increase the quality of the video:
You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.
Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.
Hi, I don't have SQL Server installed on my machine as I use MySQL instead.
Most of the code works as-is (you have to get a MySQL-specific connection string first) except for the cursor type. I found that using "adOpenForwardOnly" doesn't work properly - only a few columns of data end up on the Excel sheet. So I switched the cursor to "adOpenDynamic" and things seem to work the way they should.
I don't have a huge database to work with so I don't notice any performance problems as of yet but will let you know if I run into any.
BTW, these videos are great! Thanks for making them!
Bob
Useful information, Bob, thanks for taking the time to send it!