Excel to Access
 

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

Excel to Access
 

Hi Mike

http://www.erlandsendata.no/english/...badacexportdao

I believe it will work without Access installed

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message ...
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

Excel to Access
 

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/de...daotoadoupdate
..asp for sample code on connecting to the database and reading / writing data.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Mike" wrote in message
...
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

Excel to Access
 

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

P


"Mike" wrote in message
...
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