msfirsttrust
Board Regular
- Joined
- May 27, 2004
- Messages
- 115
Is it possible to import a text file into an Access db and have it bring in the file name as a field in each record?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Importing File Name
- Thread starter msfirsttrust
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
It would be possible but I think you would need some VBA code.
That would first import the file to wherever, then run a update query to add the filename to a field in the newly created records.
The exact code to do this sort of thing would depend on what you're actually doing.
That would first import the file to wherever, then run a update query to add the filename to a field in the newly created records.
The exact code to do this sort of thing would depend on what you're actually doing.
Upvote
0
Similar threads
- Question
