ecawilkinson
Registered User.
- Local time
- Today, 03:03
- Joined
- Jan 25, 2005
- Messages
- 112
hi,
I knw how to import a delimited text file in VBA if I know in advance what the delimiter will be. The reason you have to know in advance is that you have to save the specification so that you can then use it in the
command. So, for instance, if you know you will be importing a file that is comma-delimited, then you can save a specification that contains that information. My problem is that I am not going to know in advance what the delimiter will be. The only thing I can think of is to anticipate as many possibilities as I can and save them all as separate specifications. This just does not seem very satisfactory to me, so can anyone suggest a better way?
I thought I could solve it if I could work out how to save a specification using VBA but I can't work out how to do that.
Thanks in advance,
Chris
I knw how to import a delimited text file in VBA if I know in advance what the delimiter will be. The reason you have to know in advance is that you have to save the specification so that you can then use it in the
Code:
Docmd.TransferText acImportDelim, SavedSpecName
I thought I could solve it if I could work out how to save a specification using VBA but I can't work out how to do that.
Thanks in advance,
Chris