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

Excel data to Access

Status
Not open for further replies.
joealton

joealton

Electrical
Joined
Feb 25, 2003
Messages
1
Location
US
I'm trying to pull data from certain fields in excel from access using vba code.
 
Sort by date Sort by votes
Turn on the macro recorder and go to Data>Get External Data>New Database Query. Take a look at the code and it should give a pretty good idea of how to set it up.

patrick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BhagyeshVashi
  • Locked
  • Question Question
Need a rename macro for excel
Replies
11
Views
1K
sdz
sdz
Tuckabag
  • Locked
  • Question Question
Acessing CMD shell in Excel/VBA with keystrokes and copying resultant data
Replies
8
Views
1K
3DDave
3DDave
vinodnx7
  • Locked
  • Question Question
Micro to compare two excel file for mirror change
Replies
4
Views
1K
vinodnx7
vinodnx7
Lion_Engineer
  • Locked
  • Question Question
[Excel] Complicated Data Extraction
Replies
3
Views
413
EireChch
EireChch
Kenja824
  • Locked
  • Question Question
excel Formula Find help
Replies
5
Views
1K
Kenja824
Kenja824

Part and Inventory Search

Sponsor

Back
Top