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

Easy Import from EXCEL....

Status
Not open for further replies.
sam1one

sam1one

MIS
Aug 30, 2002
49
US
We have a lot of spreadsheets that are sent/received every month (about 13) that track store renovations. Some of the information is repetitive.

What is the best way to capture the most recent data into Access (other than an append table query?)

Thanks,
Sam
 
Sort by date Sort by votes
sam1one,


Are you asking a technical question or a design question or both???

Technical (example) see help for more info..
Code: 
DoCmd.TransferSpreadsheet acImport, 8, "tblAssets", "C:\Inventory\Stock.xls", True

Design ??


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
2K
PrimoSteve
PrimoSteve
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
647
PrimoSteve
PrimoSteve
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
785
TomSalvato
TomSalvato
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
779
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Sending data to Excel 1
Replies
2
Views
309
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top