Hi, I'm trying to do something here in Access and I'm not sure if it's possible. I want to take 165 txt files and merge them together in Access. They are all in their own folder with the same filename. They are created daily and will have 24 records each. How can I go about doing this??? Thanks for the help!!
Is this even possible???
- Thread starter ACE
- Start date
Calvin
Registered User.
- Local time
- Today, 00:25
- Joined
- Jun 4, 2003
- Messages
- 286
Write a recursive function that uses the DIR() function looping through subfolders captureing txt file paths and then uses that path with the TransferText method.
Lookup "Dir Function" and "TransferText Method" in Accesses VBA help files or search this forum, there are hundreds of examples.
Lookup "Dir Function" and "TransferText Method" in Accesses VBA help files or search this forum, there are hundreds of examples.
