3
votes
1answer
37 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
0
votes
1answer
33 views

Best way to share an Excel with an ODBC connection?

What's the best way to share within local network any Excel file that uses ODBC? I guess any user must define the ODBC connection locally in order to reload the data. Is there a way to dump an ...
0
votes
1answer
36 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
88 views

Sage Line 50 ODBC Driver Causes Crashes in application when run

I can open up a connection to my sage line 50 version 2014 file via the odbc link in visual studio and see all the tables. However, when I try to execute a query, the program comes up with "Visual ...
1
vote
1answer
37 views

Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...
0
votes
1answer
725 views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
0
votes
1answer
168 views

How to reference individual cells in Excel to variable data from records in an external SQL table

I have a SQL table containing date oriented financial data eg. multiple daily records with fields for Date, Account code and Value. I want to set up dynamic links (formulas) from cells in an Excel ...
1
vote
1answer
54 views

Restrict ODBC setting changes

I have an ODBC connection created to an IBM server. This connection is used by Excel files to read data from this server. I want to restrict users from changing any of the ODBC settings either in the ...
0
votes
1answer
644 views

Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe. I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver. When I go into Excel bring in the ...
2
votes
1answer
3k views

Error when refreshing data from external source in excel. Data source name not found and no default driver specified

I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error: ...
0
votes
1answer
444 views

iodbctest works but Excel says “No ODBC driver installed”

I'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed" What are the ...
1
vote
1answer
788 views

Querying big databases with Excel

Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
1
vote
2answers
606 views

How to have a whole, refreshable MySQL database inside Excel

I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want: I know how to import a MySQL database into Excel. I know ...
2
votes
2answers
2k views

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection ...