odbc

I am running the same query from crystal reports and excel vba. The crystal reports runs in about a second. Excel VBA takes 26 seconds. They both are going through the same ODBC connection. The query comes directly from crystal reports > Database > Show SQL query The vba code is simple...

Hello I have an Excel 2010 file with a macro built into it to refresh several tables drawing from an outside source (AS400/PRMS specifically). The file is set up in a such a way that the tables are condensed & combined into an easily readable report. The report will be used by several...

I need a timeline similar to this, that I saw in another post. (I'm a newbie to this forum, and for some reason, the link to a similar chart is not showing when I submit this post. Hence, I am morphing the link a bit so as to try to get it to show in this thread) http: //www...

I'm trying to refer to (a row of) cells in a different tabpage within Excel. The Excel file is connected to an external database and I'm using a parameter to select a specific personcode which then returns a set of data belonging to that specific person. I basicly want one tabpage of raw data...

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

Does anyone know of a way to get the data from an ODBC query initiated via Excel to return the data as data? For instance, there are three options when importing data: Table, Pivot Table Report, or PivotChart and Pivot Table Report. I am looking to just get the data without any additional...

We received an Excel spreadsheet that is actually an XML document. Excel can open it a-ok however we need to consume it using: "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" and when the program accesses this XML document it fails. Modifying the program is not a great option. However...

Every time i want to refresh data from accounting database, DB login window pops up. Is it possible to add the login and password into the connection string below to bypass the login window?? Thanks With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...

I am using ODBC to customer db. each customer has two services (water & sewer) the db breaks out the services onto two lines with an amount owed for each service. I need to create a flat file with the total amount owed. Does anyone know how to group the customers and aggregate the amounts into...

Hi All, I want to export data from Excel 2007 worksheet to i Series. Can I build an ODBC connection? Is there an option for creating a macro which will FTP data to iSeries server? Please advise. Thanks in advance.

I currently have an access database that is linked to a another data source and they mirror each other. I have spread sheets that access this information and i was curious if it's possible to have the Access Data source updated/refreshed "Real Time". I normally had to generate the list by...

Hello, This is my first post so if anything is wrong with it I apoligize in advance. I have looked everywhere and come up empty handed trying to make a macro that exports an excel table to SQL server through an odbc connection. As of right now, I currently am able to access the database and...

Hi, I hope somebody can help me. I am using ODBC to connect to a Excel 2003 worksheet and select the data. For the most part this is working just fine, however in one particular column of data has values which are both text and numbers stored as text (In different rows, obviously!) When I...

Hello all, I am trying to use my program to set up an ODBC connection on the user's computer. I am trying to make it more user friendly for the other people that may want to use my file in the future, and it entirely depends on this database query. Below is some code that I tried for...

Hi All, I have a spread sheetwith 7 Pivot Tables per sheet and about 10 sheets. It all works well but i would like to have a Macro that will allow me to input a date range then refresh all pivot tables to the same date range preferably by a nice user box that would pop up. I am new to...

I have a file in Excel 2007 that pulls data with the ODBC from a LAN. It is set to refresh upon opening. However, this file will be used by many within the company and the user must enable external data for the current data to come through. Here is my question. Is there a way (through VBA or...

Quick Summary: Is it possible to simulate closing Excel and opening Excel from within a workbook using a Macro? Some Details: Basically I have a workbook which runs and when it is done I see that the memory use (in the Ctrl+alt+del system tasks section) for Excel is at 1,250MB. It won't let...

Hi again, Basically I would like to connect to a text file that I have saved (which has lots of data so I want to pick out the pieces to import into excel). I can do this just fine on my own, but I want to set it up so that some of my colleagues can accomplish this by just saving their text...

Hello, I have a workbook that I created to import any table on our SQL server via ODBC and once I am done with table I completely clear the worksheet to it's original state (as if I just inserted a brand new sheet) and before I import another table, I would like to be able to loop through all...

Hi, An awkward problem here I suspect! Creating a pivot from a text file, read in via ODBC. This works fine, so naturally they want to change it :rolleyes: Currently: Set objMyPivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) With objMyPivotCache .Connection =...