PearlGI
Registered User.
- Local time
- Today, 03:08
- Joined
- Aug 30, 2001
- Messages
- 125
If I import a tab delimited file into Access by hand it auto-detects it as tab delimited.
Why then, if I try to replicate this using VBA does it exist on thinking it's comma delimited
The line I'm using is this:
DoCmd.TransferText acImportDelim, , "Import", strPath & strFile, True
Is there any way of informing Access that the file is tab delimited?
Yes, I know usually you would use an import specification. But in this situation the structure of the import file is unknown and hence I can't use a spec.
Any ideas?
Why then, if I try to replicate this using VBA does it exist on thinking it's comma delimited
The line I'm using is this:
DoCmd.TransferText acImportDelim, , "Import", strPath & strFile, True
Is there any way of informing Access that the file is tab delimited?
Yes, I know usually you would use an import specification. But in this situation the structure of the import file is unknown and hence I can't use a spec.
Any ideas?