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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update a table from a temp import table in Access 2003

Status
Not open for further replies.
JoeVegas

JoeVegas

Programmer
Oct 3, 2001
53
US
Access VBA Newbee - how do I move data from a temp table created/imported via TransferSpreadsheet from Excel and update a related table in the same Access DB. Help - TIA

 
Sort by date Sort by votes
For starters create an update Query
joining the 2 tables
 
Upvote 0 Downvote
Just had a thought, why not import the data from the TransferSpreadSheet Excel data directly into the related Access table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
362
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
419
Moss100
Moss100
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
657
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top