conn

Hi A problem that's only started happening on my spreadsheet in the last couple of months. I've got some VBA that works fine if I sit there and watch it.....it does everything it should. It finishes all of its loops and Excel stays open as it should. Whereas if I don't sit there watching for...

Hi, I have created a User DSN and successfully created a linked table in Microsoft Access with that DSN, however through excel vba when I tried to fetch data from that linked table an error message is displaying "ODBC --connection 'SERVERNAME' failed. However I am successfully able to fetch...

Hi, I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing. Note:- I am manually successfully able to refresh ms-access linked table in...

Hey there, I have following code like this: Private Sub CommandButton5_Click() Const adOpenKeyset = 1 Const adLockOptimistic = 3 Const WORKSHEETNAME As String = "MIP_solution" Const TABLENAME As String = "Table1" Dim conn As Object, rs As Object Dim tbl As ListObject...

I'm looking to create a workbook connection through VBA but not from a file. I have a connection string that I am going to use to connect to a SQL database, however I'm not having any luck actually getting it to show up on the connections UI. The logic basically is to 1) Run through sheets 2)...

Hi All, I am having runtime error 2046 The Command or action RunSQL isn't available on the line with red font. Thanks for any help and insight. Sub UploadRelevantColumns() 'The path to create the new access database Dim StrPath As String 'An Access object Dim ObjAccess As Object...

Hi All, I am having runtime error 2046 The Command or action RunSQL isn't available on the line with red font. Thanks for any help and insight. Sub UploadRelevantColumns() 'The path to create the new access database Dim StrPath As String 'An Access object Dim ObjAccess As Object StrPath =...

I have no prior experience with SQL databases, so this is my first try. Please bear with me... My database is a regular *.sqlite file which I'd like to connect to Excel through ADO interface using VBA. The connection string (ConnectionString) below is taken from...

Guys I'm a newbie with OOP (Object-oriented programming) I need your assistance to develop a connection inside a class so I can get/access this connection on a module. Here below the function the connects to the SQL Server that is working fine. What I need is make reference to this function...

I have about 30 connections connected to different excel sheets within 1 workbook. I want to know how to get the command text for each connection using VBA code. This is what I have thus far: Function Connections() Dim conn As WorkbookConnection Dim celltxt As String For Each conn In...

In the following,there is just one line of code I can't get right. Any ideas on this? I am trying to take a text string and upload it from my computer to an external server. The error message is [Microsoft][ODBC Drive Manager] Data source name not found and no default driver specified...

Hi all I'v got a query that's supposed to bring back data into a recordset but it's only bringing back the first two columns. The query looks like this:- Option ExplicitDim conn As ADODB.Connection, cmd As ADODB.Command, rs As ADODB.Recordset Dim strConn As String, strQry As String Dim wsData...

Hi, I am getting the following error message and am not sure how to get rid of this. 'Run-time error - 2147467259 (80004005): Method 'CopyFromRecordset' of object range failed. The VB code is as follows: Sub GetDataFromSql() Dim conn As New ADODB.Connection Dim rs As ADODB.Recordset Dim...