Can MS Acess be linked to an Excel worksheet?

M

Madhart

I'm taking a shot in the dark here but can MS Acess be linked to an Excel
worksheet? At work we use Acess(gatelog) to track people in and out. We
then transfer those times for people manually to an Excel worksheet. Is
there any (hopefully easy) way to link the two so the Excel worksheet is auto
updated with all the same information? If so how would I go about that and
what all would need to be involved?

Thanks.
 
D

david

You can't update an Excel worksheet. Somebody got a patent for that and
tried to screw money out of MS.

You might be able to append data to a spreadsheet, or even create a
new spreadsheet.

Start by using the menu command File | Save As/Export to create a
spreadsheet. When you have that working, you can create a macro
or form that does the same thing using docmd.TransferSpreadsheet.

(david)
 
A

a a r o n . k e m p f

a) keep your data in SQL Server
b) build a cube so that people can leverage 'pivotTables on steroids'
c) always give people fast, flexible data using 'Analysis Services'.

anything else is a waste of time.
 
A

a a r o n . k e m p f

or.. JUST A SIMPLE ADO RECORDSET

that way you don't need Excel installed, I believe
 
A

a a r o n . k e m p f

bob;

I've never been
irrelevant
insulting
or
erroneous

but thanks-- I'd just reccomend not stalking me, asshole
 
A

a a r o n . k e m p f

a) **** you stalker-- you follow me around and attack whatever I say.
that meets the definition of 'stalking'. GUARANTEED.
b) i'll call you an asshole whenever I want- as long as you keep on
stalking me
c) just another symptom that dipshits like you should be using ADO.

at least I'm not using an obsolete database that corrupts once a
month.
You should be ashamed of yourself, stalker
 
A

a a r o n . k e m p f

it's not _THE_ engine in Access.
it's ONE of the engines in Access.

Jet fucking corrupts. Everything else is just an excuse.
 
A

a a r o n . k e m p f

and how the **** do you think that i'm stalking you?

you follow me around on these newsgroups.

repetive unwanted contact.

stop following me around, stalker
stop following me around, stalker
stop following me around, stalker
stop following me around, stalker
 
P

posted_by_anonymous

a a r o n . k e m p f @ g m a i l . c o said:
or.. JUST A SIMPLE ADO RECORDSET
that way you don't need Excel installed, I believe
Click to expand...

Related to original post? Even remotely? Even very, very remotely?

When are you going in for your craniorectomy, troll?

Aunty No-ny-muss
 
D

david

I don't think an ADO Recordset would work, but I haven't tried it.
The way the patch was introduced was odd an bizarre, so I don't
think there is any sensible way to predict the behaviour of an ADO
recordset other than trying it.

As I recall, the patch was a patch to MSACCESS.exe, (so linked
tables can't be updated), but Jet was patched to use MSACCESS.exe
instead of the Excel IISAM, (so DAO recordsets can't be updated)
or something like that.

In any case, given the lack of explicit documentation from MS, the
only way to find out if an ADO recordset on an Excel spreadsheet
is updatable is to try it and see.

(david)
 
G

George Hepworth

The best way to deal with trolls is to ignore them with one exception.
Sometimes it is necessary to correct an inaccurate or misleading statement.

However, most posters are smart enough to figure out very quickly who the
trolls are all by themselves.

George
 
A

a a r o n . k e m p f

why don't you think that you could use an ADO recordset to update data
in Excel?

I do this all the time!
 
A

a a r o n . k e m p f

re:
but can MS Acess be linked to an Excel
worksheet


YES, the OP was asking about updating Excel from Access.
I choose to do this through ADO because ADO is rock solid and it works
against hundreds of database engines.

DAO only works against JET; and it has too many layers for effective
troubleshooting
 
D

david

That is the reason Aaron. People assume whatever you say is worth only
as much as everything else you say.

I've done my best, pointing out that what you implied may be true, but
I doubt if anyone is listening.

(david)


message
why don't you think that you could use an ADO recordset to update data
in Excel?

I do this all the time!
 
Top