Data transfer - Excel to Access

C

Chris

I am a newcomer to Access and am trying to set up a simple
database at work. I have linked and created various
spreadsheets to my database through the OLE object command
on a field. However, I now want to transfer a figure in
one cell of my spreadsheet to my database so that every
time I change its value on the spreadsheet, it
automatically updates in the database.
Is there a way to do this? Any help would be gratefully
recieved as i have been pondering over this for some time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top