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.