LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Andy Wiggins
 
Posts: n/a
Default

As you have found out, this add-in is no longer included with Microsoft
Excel. You can get it from Microsoft by following this link -
http://office.microsoft.com/downloads/2002/xlodbc.aspx

This is where Uncle Bill isn't being too helpful :-(
Here's how to get the files::
Open the xlodbc.exe using, say, Winzip.
Copy the files to a convenient location.
From within Excel, browse to the add-in file and load it as normal

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"M.Heer" wrote in message
...
I have found that the SQL.REQUEST function is not an option in Excel 2003

any
longer. Is there another function that will access data stored in an SQL
server?

"Harlan Grove" wrote:

"M.Heer" wrote...
I understand that. The problem is that in order to have the SQL.REQUEST
function work you need to have Excel ODBC installed and I can't find
where to get that for Excel 2003 version. On the microsoft website they
do have the download available, but it is for Excel 2002 and XP
versions-- will not work on Excel 2003 version. . . .


And are you *CERTAIN* of that last statement?!

In fact, it's PRECISELY the 2002/XP version you need since it hasn't

changed
since Excel 95. [Look under the hood - it's XLM code calling an external

DLL
that still carries the Excel 5.0 version label.]

The only mystery here is why, in its infinite wisdom, Microsoft chose to
drop the ODBC add-in from the Office product CD.





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors X_HOBBES Excel Discussion (Misc queries) 0 March 15th 05 06:46 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM
Lookup Access data in Excel Chris Kellock Excel Worksheet Functions 1 December 28th 04 01:51 PM
populating data from excel into access Chris Links and Linking in Excel 1 December 15th 04 07:50 AM
Problem Code: Retrieving Stored Access 03 Query Bettergains Excel Discussion (Misc queries) 2 December 7th 04 04:11 PM


All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"