Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spreadsheet using SQL.REQUEST - System Requirements
I've just put together a spreadsheet that pulls data from tables in an
access database using SQL.REQUEST. Since I have Access, I didn't, until just now, give a thought to the fact that most of my users are running the Std Edition of Office 2000 and do not have Access installed. I plan to place a local copy of the database and spreadsheet on the machines of the users who will use this (laptop users). My question is, will the spreadsheet properly connect to and query the .mdb if Access isn't installed on their machines? Will I need to install Access for these users? Thanks, Bryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spreadsheet using SQL.REQUEST - System Requirements
"Bryan Linton" wrote ...
I've just put together a spreadsheet that pulls data from tables in an access database using SQL.REQUEST. Since I have Access, I didn't, until just now, give a thought to the fact that most of my users are running the Std Edition of Office 2000 and do not have Access installed. I plan to place a local copy of the database and spreadsheet on the machines of the users who will use this (laptop users). My question is, will the spreadsheet properly connect to and query the .mdb if Access isn't installed on their machines? Will I need to install Access for these users? No. AFAIK, you only need the Excel ODBC add-in, the mdb file, the mdw file (if applicable), the driver you are using and the DSN (if applicable). Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
Material Requirements Plan (MRP) and Capacity Requirements Plan (C | Excel Worksheet Functions | |||
Material Requirements Planning-MRP/Capacity Requirements Planning- | Excel Discussion (Misc queries) | |||
SQL.REQUEST linking Excel to Oracle - file dsn vs system dsn? | Excel Programming | |||
Creating Multiple ODBC System DSNs from an Excel Spreadsheet | Excel Programming |