-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
connection strings
-
F
Batch replacing External Connection Stream
Hi, I currently have a spreadsheet that includes lots of pages imported from external data (an external website). The links that I used were similar to: https://www.twitrss.me/twitter_user_to_rss/?user=barkingcollege However recently there has been an issue with a security certificate on...- fluffynicesheep
- Thread
- connection strings data link find and replace vba connection string
- Replies: 9
- Forum: Excel Questions
-
Connect to Protected 2007 MS Access Database mdb file
Hi everyone, I have userform and transferring some data to closed excel files. This data collecting in MS Access mdb database and I want to protect this. I found a string from the net and I connect unprotected my mdb file successful. These codes are below but I don't know how can I connect my...- FalconBLUE
- Thread
- adodb.connection connection strings file mdb password protected
- Replies: 1
- Forum: Excel Questions
-
T
Read Only Connection though New Query:From Database:From Access Database
Using the older From Access button, I used to make the connections to Access read only before they were created. Otherwise, I end up not being able to save my Access VBA in that database until I close Excel. With this newer type of connection, I haven't figured out how to do it. It's not...- tbaker818
- Thread
- connection strings read only
- Replies: 0
- Forum: Power Tools
-
Need help fixing macro that changed ODBC connection string - was VisualFoxPro now SQL
My reports used to connect to our database using a VisualFoxPro ODBC driver, but the new version of the database requires an SQL connection. I have been able to connect just fine, my problem is that I need to modify the macro that lets me change the database path when the report is given to...- 9tanstaafl9
- Thread
- connection strings excel 2013 macro issue odbc connection query sql connections
- Replies: 1
- Forum: Excel Questions
-
J
Update Connection String's IP address with cell content change
I've got a spreadsheet consisting of several ODBC queries that I need to distribute to multiple individuals. The ODBC server's IP address in the Connection String will be different for each individual so I'm looking for a way to update the server's IP address based off of an IP address I enter...- jeff_cp
- Thread
- connection string connection strings ip address odbc odbc connection
- Replies: 1
- Forum: Excel Questions
-
T
SQL Connections To Tables Within Same Excel Spreadsheet
Hi all, I'm hoping that someone on here might be able to help. I've created a workbook which contains tables of data on individual sheets (see example below) On Sheet1 I have an SQL statement which queries these tables using the connection "From Microsoft Query" and then I've chosen that...- tjh392
- Thread
- connection strings excel query solved sql
- Replies: 9
- Forum: Excel Questions
-
Connection String Relative Reference Requiring DSN
Hi guys, I've got a workbook that pulls data from an access database. MS Query created the following connection string which works just fine: DBQ=C:\Users\t5264ab\Desktop\Dashboard\Claim Analyzer Total 13MY YTD.mdb;DefaultDir=C:\Users\t5264ab\Desktop\misc docs;Driver={Microsoft Access Driver...- Juglaz
- Thread
- connection strings dsn sql
- Replies: 5
- Forum: Excel Questions
-
T
Excel VBA Connection to Access
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...- Twi78
- Thread
- access ado array connection strings database recordset
- Replies: 15
- Forum: Excel Questions
