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?

Dom

Can you post the code your using to export?