Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 593
Default 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
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
How do I open an Excel file on XP system, saved on a Vista system JLS7 Excel Discussion (Misc queries) 3 December 2nd 08 04:21 AM
Material Requirements Plan (MRP) and Capacity Requirements Plan (C Tricia Young Excel Worksheet Functions 1 February 1st 07 06:55 AM
Material Requirements Planning-MRP/Capacity Requirements Planning- Tricia Young Excel Discussion (Misc queries) 1 February 1st 07 06:22 AM
SQL.REQUEST linking Excel to Oracle - file dsn vs system dsn? D[_7_] Excel Programming 1 August 6th 04 09:42 PM
Creating Multiple ODBC System DSNs from an Excel Spreadsheet Mark[_22_] Excel Programming 1 October 21st 03 05:06 AM


All times are GMT +1. The time now is 02:14 AM.

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

About Us

"It's about Microsoft Excel"