connection string

I created 11 different tabs to be filled out. Is there a way to have the data in each of those sheets auto-populate into one master sheet? I need to show the totals of each product selected. I only included the Master Sheet and 2 tabs below. Thank you for your help. Master Sheet...

I saw this old thread Automating Importing IQY Files and used that code as well as recorded my own macro. Here is my code. Sub Macro1() Workbooks.OpenDatabase Filename:="C:\New folder (2)\Data\Test2.iqy", _ CommandText:=Array( _...

I'm using OLE DB CopyFromRecordset and getting empty cells where there should be text. My connection string is supposed to be disabling the automatic type guessing, but it looks like that's not happening. For instance: row 1 has a floating point value, rows 2-12 are empty, row 13 is text...

Hello everyone, I have a scenario where, every day, I have to manually set the Data Source credentials to Windows Authentication in order for my queries to refresh. I currently have a few queries that connect to two different excel databases (one on SharePoint, and the other on our company's...

Dear All master, I want to connect with multi data source for dbf file with vba array code. what I want is the following: 1. Modify the connection string according to the dbase file provider 2. Can I connect with my multi DSN reference and become one sheet Data Source Name DefaultDir FILE NAME...

Hi I am connecting to oracle database in vba via c.Open "Driver={Oracle in OraClient12Home1_32bit};" & _ "Server=" & sServer & ";" & _ "Uid=" & id & ";" & _ "Pwd=" & pw & ";" & _ "DBQ=" & service_name However when i copy from the...

Hi, I want to pick only one value from an SQL base. I know how to bring a whole tabel to Excel. I use: With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _ "ODBC;DRIVER=SQL Server;SERVER=192.168.0.10\SQL;UID=sa1;PWD=password;APP=System operacyjny Microsoft®...

Hello all, Has anyone else received this error? I have narrowed down the line that causes the error (bold in red below in second sub) but can't seem to fix it. I recently got a new computer using 64 bit Excel 2016. PLEASE HELLLPP!!!! Function AddConnections() As Integer'Adds data...

I have an Excel project which uses MS ACCESS for data storage. Works fine. The issue is that ... The project is used by multiple persons in multiple locations, making synchronization of data tedious (each one has to export what they have done via proprietary files and similarly import changes...

I have been struggling so long with this and I'm really in dispair since my last finding was that not all connection types can be updated. I have a PowerPivot that sources the data from another Excel file. I want to be able to send this PowerPivot file to a number of users and they should all...

Hi, I am using a macro enabled .xlsm Excel 2007 workbook. I have 4 data connection to the same Access 2007 file from which I get various pivot tables. My issue is that the spreadsheet works perfectly for me and others in my office, but one colleague in another office (who has Office 2007)...

Hi everyone, I'm trying to operate a macro that loops through all connections strings in a workbook and defines them to their base form as defined in "DBPath" range below. Is there any way to do this? I get a run time error '13' type mismatch with what I'm currently trying below. Any help would...

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...

Hi guys, So I have a macro that pulls data from a mySQL table from a database on localhost server. I have another mySQL server which has been successfully connected to a cloud SQL instance in the Google Developers Console. I would like to take the existing macro I have and rather than pull...

Hey all, we have a whole bunch of sql server instances that have the same database and table, id like to be able to update my excel spreadsheet which connects to it via a macro instead of manually going in and changing the server each time. its windows auth all the way, if that helps simply...

I have the following connection string that apparently is causing an error "Could not find installable ISAM" error when I open the Excel 2010 file on Windows 7. The queries in the file connect to an Access 2002 database. I installed the "Microsoft Access Database Engine 2010 Redistributable"...

My spreadsheets have a connection to SQL for source data. Since it is a new year I need the year part of the query to read 1/1/14 instead of 1/1/13. However the identification part of the query is unique to each workbook. I cannot find a way to update just the section of the connection string...

Hi, I am a little out of my element with this one: With VBA in Excel 2010 I am connecting to a SQL server by using ODBC. This is a two part process: Part one: I have created a connection string that gets me the following data: A, B, C, D, E from sheet tpoPurchOrder Where B is equal to "1"...

Hello all! Im trying to insert my record set (using SQL 2005 server [server 2008r2 upgrade coming soon] and office 2013) into a named table "test". (Activeworksheet - for testing purposes.) The purpose is so I can manipulate the data (add columns- remove columns -write formulas in between the...