Home |
Search |
Today's Posts |
#8
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Lookup Access data in Excel | Excel Worksheet Functions | |||
populating data from excel into access | Links and Linking in Excel | |||
Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) |