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!

Import excel data into access

Status
Not open for further replies.
jurgen

jurgen

Programmer
Feb 8, 2001
209
BE
How can i import (using vba) sheets in excelfiles into an access database. The excel files have named ranges.

I've got 2 files with 3 tabs, al in the same layout and i want that data to be imported in 1 table to use in the application.

Can someone help me were to start
 
Sort by date Sort by votes
Hi...
Take a look in Access Help for the TransferSpreadsheet method.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
488
Viswa.R
Viswa.R
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
3K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
3K
Andrzejek
Andrzejek
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
709
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top