Excel to Access - User needs Access installed?
 

Hi group, quick question. If I have a macro to upload some Excel data
into Access, can this macro be used by a user without Access
installed on its PC???? The Access database is located in a shared
drive, the Excel is stored in the user's PC.
....And same thing in the other way, can a user without Access import
from Excel some Access info??
Versions are Excel 2003 and Access 2002.
Thanks in advance,
Cecilia

Excel to Access - User needs Access installed?
 

Can you buy Excel without buying the entire Microsoft Office Suite?
I'm not sure if there are variations in the way microsoft sells products
in different countries so It may depend on where you bought Office and
from whom you bought Office.

Excel uses the libraries in Windows\system32 folder (DLL's) to do
perform this function and it really depends on the DLL's that are
installed on a PC if reading/writing to a database is possible.

Checking the libraries that excel uses to read/write to Access is in
the OFFICE folder and is called MSACC.OLB, and to perfrom ADO function
excel uses MSADOXX.dll (the XX depends on the verion office installd).
I would do a search on the Microsoft Office Folder for these files to
get the exact answer. It may depend also on the manufacturer of you PC
since different PC manuafactures install different variations of
microsoft procducts some may havve these installed an others may not.
It depends on the licensing agreements between the PC manufactures and
microsoft.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181365

Microsoft Office Help

Excel to Access - User needs Access installed?
 

On Feb 22, 8:34*am, joel wrote:
Can you buy Excel without buying the entire Microsoft Office Suite?
I'm not sure if there are variations in the way microsoft sells products
in different countries so It may depend on where you bought Office and
from whom you bought Office.

Excel uses the libraries in Windows\system32 folder (DLL's) to do
perform this function and it really depends on the DLL's that are
installed on a PC if reading/writing to a database is possible.

Checking the libraries that excel uses to read/write to Access is in
the OFFICE folder and is called MSACC.OLB, and to perfrom ADO function
excel uses MSADOXX.dll (the XX depends on the verion office installd).
I would do a search on the Microsoft Office Folder for these files to
get the exact answer. *It may depend also on the manufacturer of you PC
since different PC manuafactures install different variations of
microsoft procducts some may havve these installed an others may not.
It depends on the licensing agreements between the PC manufactures and
microsoft.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=181365

Microsoft Office Help

Thanks Joel for your answer!! All the users have corporate PCs, with
just Excel and a few have Access. But you mention a good starting
point, I will try it by researching more around the DLLs.
Thanks!
Cecilia