Hi,
I'm linking to a txt file which works well. The second column contains mainly numbers, but now and again a bit of text as well.
When linking, the numbers all appear, but the text records produce a #Num! reading.
Does anyone know how to specify the second column as being a text column in a newly linked txt file.
The same problem happens if it is a csv file as well.
This is the code I've used:
DoCmd.TransferText acLinkDelim, , "nodesready", _
Forms![runselection]![SourceDirectory] _
& "\nodesready.txt", True, ""
Many thanks
Hugh