Myriad_Rocker
Questioning Reality
- Local time
- Today, 04:21
- Joined
- Mar 26, 2004
- Messages
- 166
I have an objective that I need to do and I thought, at first, that it was just to import in a text file using VBA...but now I'm not sure. Here's the objective:
Write a program (do not use DoCmd.TransferText) to convert "test.txt" to a tab delimited file.
All fields must be trimmed of extra spaces.
Include a form to specify the input and output and a button to run the conversion.
So...where do I start? Any hints, tips, or tricks are mucho appreciated.
I have attached the text time I'm supposed to be working with.
Write a program (do not use DoCmd.TransferText) to convert "test.txt" to a tab delimited file.
All fields must be trimmed of extra spaces.
Include a form to specify the input and output and a button to run the conversion.
So...where do I start? Any hints, tips, or tricks are mucho appreciated.
I have attached the text time I'm supposed to be working with.
Last edited by a moderator: