Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Excel to update or append Access DB

Status
Not open for further replies.
dfarland

dfarland

Technical User
May 9, 2003
16
US
I know how to open an Access db with Excel with DAO. How can I update any changes or append the Access db with the db in Excel?
 
Sort by date Sort by votes
Sure, assuming your already getting the recordset:

rs.edit (been awile - please feel free to correct code)
..change data here
rs.update (applys changes to the db)

 
Upvote 0 Downvote
I can't seem to find any documentation on these edit and update, are they, methods? Is there some available?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
544
remeng
remeng
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
272
feipezi
feipezi
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
425
hermanlaksko
hermanlaksko
foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
204
foxup
foxup
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
134
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top