Excel to Access

[Mike]

Hi all,

I've got a number of users that have excel installed on
their PCs, but not Access. I would like to start an
Access database that these users can read from (queried
through Excel) and write changes to the database. I can
import the data no problem using Microsoft Query, but is
there a way to update the tables in the access database
using only Excel?

Any tips or points in the right direction would be
greatly appreciated,

Thanks in advance,

Mike

 

[Ron de Bruin]

Hi Mike

http://www.erlandsendata.no/english/index.php?d=envbadacexportdao

I believe it will work without Access installed

 

[Harald Staff]

Hi Mike

If you're willing to code a little <bg>, you can build a complete front-end in Word or
Excel or Outlook using VBA and some sheets/whatevers and some userforms. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate
..asp for sample code on connecting to the database and reading / writing data.

 

[Phobos]

Use "linked tables" in Access, any changes made to the SS are automatically
updated in the DB.

P