connection problem

Again I have a hybrid Access/Excel question/issue.. The problem is that I have a somewhat complicated query in Access. It is populating all of the fields exactly as expected and how I want them calculated. This query is set up as a connection which drives a pivot table in Excel. It looks like...

Ladies and Gents, I've come across an extremely puzzling issue. I'm attempting to connect to a MySQL db through PowerQuery. I downloaded the mysql connector (originally version 6.6.5 but rolled back to 6.4.6 in an attempt to resolve this issue) and connected to the db. So far so good. It asks...

I've literally run out of things to try. I have cubes deployed to an SSAS Tabular instance. They have Dynamic Roles set up to limit data to only data they should have access to. This Role has Everyone assigned to it. It seems to be functioning fine for everyone at the company so far except 1...

Hello everyone, I am having issues linking workbook B to my current workbook A. I know it's easy to do and I have done it in the past like this: Existing connections --> Browse for More --> Select file Then I would get a window like this one (View image: excel select tab) where I could choose...

Dear Scientists, I have a simple problem but I really can't find an elegant solution (not ctrl + c and ctrl v). Workbook "2014 Sales.xlsx" must have 12 worksheets, one per month, which one must have 31 columns that gets data from workbooks 2014 01 01.xlsx; 2014 01 02.xlsx 2014; 01 03.xlsx...

I have two data connections to different queries in the same Access DB. The second one always fails (regardless of which I run first). When I look at the database, I notice that it has a lock file after I attempt the Refresh (not before), which I think is causing the problem. It stays locked...

The code below is what I am currently using. The problem Im having is that when there are no connections at all it throws up a error "Bad Name" and highlights the If Dir("H:\") is there something I can add that I quess would check for any connection first then check for the H: Thanks If...

Hi friends, I am new to this forum and need you suggestion on a perticula query: I am trying to get some data on a excel. This data is available on a unix OS solaris server. The data is available in tebular format on the txt file in teh server and i need to populate this data on my excel...

Hello, I've got a functioning ODBC connection that allows me to execute a single select statement on Teradata. If I add another statement to the batch, it goes wrong. I don't think there is teradata version of 'SET NOCOUNT ON' so I'm now thinking that I will need to: 1. Write some VBA that...

My report runs great for everyone except person running 64 bit Excel 2010 on Server 2008. (Can't connect to visual foxpro 32 bit odbc driver using VFPODBC 32 bit) Pops up the ODBC SCREEN asking for the data source. Here is the connection string from one of the queries, they are all pretty much...

I am using import external data to get a connection and execute the query to populate some values to my sheet.. In one sheet for the columns A to U we have different queries to fill up these column. I have enabled the option "Refresh when file open" in Data properties. Since the number of...