oledb

Hey everyone, I've got xlsm files used by multiple devices to handle supervision at a client of mine, it works fine on older devices (win10 computers and win10 ARM tablets) but a newly installed windows 10 computer runs into an error at one point into the script when the code tries to invoke...

Hi Please provide help as am getting following error "Cannot complete this as data is refreshing in the background" When I am trying to run the following code ActiveSheet.ListObjects("Table_ExternalData_14").Unlist ActiveSheet.ListObjects("Table_ExternalData_13").Unlist This happens after...

Is there a way to reference an excel table via an OLEDB connection. For instance if I have a workbook with a single worksheet named Sheet1 and on that worksheet I have created an excel table named MyTable, how do I Select,Insert, etc to MyTable via OLEDB. Once I make my connection I know I can...

Hello, I'm struggling with combining SP and Excel. I've got a document lib. on SP with metadata FileName/Checked Out To/Modified by in normal view. My macro is going to open one of these files stored on SP. What I need to do is to verify if file, which I'd like to open, is Checked Out and, if...

I am creating an Access application that we need to use with SQL Server. I have a some questions that I have not been able to get answers for yet after doing quite a bit of research. I am planning on using a OLEDB connection, However I am a little confused about how to set this up. I have an...

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

Hello, How many concurrent users can connect to an Excel xlsx file using 'Provider=Microsoft.ACE.OLEDB.12.0'? Please, note that i shall use ONLY ReadOnly (understand SELECT SQL statements)! I read it's 255 as an official statement from Microsoft. Is there any additional restriction by timing...

Hi, We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'...

I have a folder with around 40 spreadsheets, and each has a OLEDB Connection. I've written a macro that process each spreadsheet in the folder, and that works! :) I'm need to change the source filename, and location, using VBA. Assume the following: - Connection Name is "ThePrices" - new...

Hi all, Hoping you could help me with the following. I have an Excel spreadsheet that draws in queries from an Access database using OLEDB. There are many queries, so rather than refresh them manually I built a macro to do so. I recorded myself manually refreshing one query and came up with...

Hello I've followed the MSN brief on my problem as best I can, but still have issues! I understand why it does it and why it happens, but can't seem to set my RecordSet and preserve optimistic locktype and dynamic cursor. If I understood it (probably not) correctly, I need to Open the...

Hi, First of all let me preface this with: I've tried hard to find the answer to this myself, so I'm sorry if this already exists on the forum. I'm trying to do a mass import into access using the OLEDB driver and "fixed width" if you notice in the below code, the commented out part is what I...

I Have a workbook which consists of 50 worksheets and i use Edit query window to pull the data from oracle on all these sheets. We run this once in a month. I have to go to every sheet and execute this code which is time consuming and i have to change the date value everytime.Please help me with...

Hi all, I have a macro that is running a query in Access. My SQL string has an array variable in it that changes on each iteration of a for-next loop. For the first K, the macro pulls the code in fine but on the second iteration I am getting a runtime error '1004' - Application-defined or...