If I am trying to export a table in access, I can use the Eport command in the file menu. There, I can specify such things as the delimiter, whether or not to use quotes around text, etc.
I assume to do this in VBA code, I need to use doCmd.TransferText. But in the argument list, I have no way to specify the delimiter. Is there another function?