Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
automatically import multiple named-ranges from Excel to Access
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="smartin, post: 3192027"] Hi Joseph, This is an Access task, not an Excel task, so you might get better answers in an Access group. The general idea I think would be to write a VBA procedure that loops through the subject XLS files and uses something like the DoCmd.TransferDatabase method to link into the files and append the range data to your table. Good luck! [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
automatically import multiple named-ranges from Excel to Access
Top
