Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and data access
i have an excel file which i distribute to other people in the organization.
i will like to also distribute either an access database or sql express database, and then have an excel add-in query the database. will this work, if my end users do not have either access or sql server? thks ken |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and data access
Excel can access an MDB file without having Access installed. I have no
knowledge of sql express. -- Regards, Tom Ogilvy "k2sarah" wrote: i have an excel file which i distribute to other people in the organization. i will like to also distribute either an access database or sql express database, and then have an excel add-in query the database. will this work, if my end users do not have either access or sql server? thks ken |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel and data access
k2sarah wrote:
i have an excel file which i distribute to other people in the organization. i will like to also distribute either an access database or sql express database, and then have an excel add-in query the database. will this work, if my end users do not have either access or sql server? Yes. For both You can distribute mdb file, and excel can read data using oledb. Could you explain whah you mean 'distribute sql express database? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Data too large for Excel, need to query Access data for results | Excel Programming | |||
Transfer Data from Excel 2000 to the Access data base | Excel Programming | |||
Access data -work in Excel- save in Access | Excel Programming |