Managing External Database Connections in Excel 12

re: Managing External Database Connections in Excel 12

Paul Morriss — Fri, 17 Feb 2006 12:44:14 GMT

Can you explain what you mean by "Note that nothing in this paragraph is new to Excel 12 – it all exists in current versions of Excel." I've got Excel 2000 and it doesn't know about odc files.

Do you mean that the concepts aren't new, but that all the stuff (like the connection string, and which cell the datasource is linked to) have been hidden away?

BTW isn't it called something new now, not Office 12? :-)

This is yet another great feature, thanks for including it. We've had to use Excel macros to get at the connection string before now.

re: Managing External Database Connections in Excel 12

Bill Schanks — Fri, 17 Feb 2006 20:00:58 GMT

For anyone needing to manage QueryTable's here is an Add-in that has come very handy:

http://www.dicks-blog.com/archives/2005/11/29/query-editor-add-in/

re: Managing External Database Connections in Excel 12

Rob van Gelder — Sat, 18 Feb 2006 01:02:40 GMT

Bill: Thanks for posting a link to my Query Editor Add-In.

One of the gripes I have with External Data is that it's not possible to supply Parameters for OLEDB query tables, though it IS possible for ODBC.
The error messages tease me. They all suggest that the OLEDB Parameters are possible, but I supplied the wrong syntax. I spent hours trying various methods without success.

OLEDB querytable Parameters will still not be supported in Excel 12 as posted by David some weeks back.

It all seems backward since OLEDB is the newer technology.

And, what is annoying is that if an MS developer took a look, they'd probably find that filling this gap would be a quick job.

So for now, I recommend sticking with (the older) ODBC.

re: Managing External Database Connections in Excel 12

David Gainer — Sat, 18 Feb 2006 03:09:03 GMT

Howdy,

Paul, good points. ODCs were introduced in 2002, so I should have said 2002 and 2003 to be precise.

Rob, thanks for the feedback.

re: Managing External Database Connections in Excel 12

video — Sat, 18 Feb 2006 11:49:51 GMT

It help me a lot.thanks.

Excel 2007 charting UX design

Alex Barnett blog — Fri, 14 Jul 2006 13:31:53 GMT

Sander Viegers is a user experience (UX) designer in the Office Design Group who contributed to Excel...

Excel 2007 charting UX design

Alex Barnett blog — Fri, 14 Jul 2006 13:36:22 GMT

Sander Viegers is a user experience (UX) designer in the Office Design Group who contributed to Excel...

Excel 2007 charting UX design

Alex Barnett blog — Fri, 14 Jul 2006 13:36:50 GMT

Sander Viegers is a user experience (UX) designer in the Office Design Group who contributed to Excel...

Switching Data Sources in Excel 2007

Microsoft Excel — Thu, 13 Dec 2007 02:25:45 GMT

Today’s Author: Howie Dickerman, a program manager on the Excel team. Howie is going to discuss different

Microsoft Excel Managing External Database Connections in Excel 12 | Paid Surveys

Fri, 29 May 2009 19:53:58 GMT

PingBack from http://paidsurveyshub.info/story.php?title=microsoft-excel-managing-external-database-connections-in-excel-12

Microsoft Excel Managing External Database Connections in Excel 12 | Wood TV Stand

Mon, 01 Jun 2009 02:32:42 GMT

PingBack from http://woodtvstand.info/story.php?id=10096

Microsoft Excel Managing External Database Connections in Excel 12 | Patio Chairs

Wed, 03 Jun 2009 05:48:05 GMT

PingBack from http://patiochairsite.info/story.php?id=26494

Microsoft Excel Managing External Database Connections in Excel 12 | patio set

Microsoft Excel Managing External Database Connections in Excel 12 | patio set — Thu, 18 Jun 2009 05:18:07 GMT

PingBack from http://patiosetsite.info/story.php?id=166

Microsoft Excel Managing External Database Connections in Excel 12 | patio umbrella

Thu, 18 Jun 2009 06:59:30 GMT

PingBack from http://patioumbrellasource.info/story.php?id=1752