DoCmd.OutputTo assistance needed...

[new_phoenix]

Hi, guys. I need some help with the DoCmd.OutputTo method in MS Access. I would like to export the file to a .CSV file but the only options that I have are as follows: AcFormat can be one of these AcFormat constants. acFormatASP acFormatDAP acFormatHTML acFormatIIS acFormatRTF acFormatSNP acFormatTXT acFormatXLS The code for DoCmd.OutputTo is as follows:

DoCmd.OutputTo acOutputTable, "tblInputFile", \_
    acFormatTXT, "C:\\test\\output.csv", True

I tried to use the acFormatTXT option to export to the .CSV file. I need the result to be a comma delimited list, but it comes out like this:

--------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | Facilities & Real | 4 | 57AU |

| USA | WFTE | SUPPORT | Global | GLOBAL | General Supply | 0 | 57AU |

| USA | WFTE | SUPPORT | Global | GLOBAL | Marketing | 0 | 57AU |

-- modified at 13:13 Monday 29th October, 2007