I have written a macro to import a delimited file from Excel into Access and it works. The only problem is that the file I specify in the macro is hard coded and I would like to give the users the option of selecting the file they would like to import and then importing it by pressing a button. Do you by any chance know how I would code this?
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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Code to Import from Excel into Access
- Thread starter Strobeman
- Start date
- Thread starter
- #3
Thanks for that. I don't suppose you could let me know the breakdown of that command? I am new to Access but have been programming for many years so I know what I want to do but am battling to find the answers. None of the books I have seem to have the answers to my questions but this site is teaching me loads.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
- Locked
- Question