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 SkipVought 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
0
0
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

feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
141
feipezi
feipezi
Andrzejek
  • Question
Outlook VBA - Trust access
Replies
3
Views
221
hermanlaksko
hermanlaksko
foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
118
foxup
foxup
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
81
aldi07
aldi07
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
165
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top