excel linked to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have an excel template liked to an access table. The date entered in on
the template is the primary key with no duplicates in access. I would like to
set up the link so a user could open the template to re-enter the report for
a past date and have it replace the data in access. Is this possible without
having to open access or the saved file from excel

Thank for your help
 
Probably it's possible to do this without opening Access, by writing
Excel VBA code that uses the DAO or ADO library to write to the Access
table.
 

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

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
VBA - retrieve data on last create named range from previous inserted named range 0
export query result from Access 2003 to specific cells in excel 2007 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access #Error & Excel Pivot 0
Importing information into an access template from excel 2
Linking Excel Tables in Access 1
Passing data from access to excel 2

Back
Top