Is is possible, from within Access, to run a Macro that will go out to a directory called C:\Bankfiles, copy the text file that is there (Validate.txt) and then paste this file name into the last record of my bank table (tblBank)?
Copy and Paste an external file name
- Thread starter lucour
- Start date
ColinEssex
Old registered user
- Local time
- Today, 09:03
- Joined
- Feb 22, 2002
- Messages
- 9,314
Hi
Can you not set up an Import specification (File>>Get external data>>>Import) and import the text file that way?
You could then run the specification via Vb either on a timer or on a button.
Col
Can you not set up an Import specification (File>>Get external data>>>Import) and import the text file that way?
You could then run the specification via Vb either on a timer or on a button.
Col
Similar threads
