Unfortunately it doesn't seem to work :
Yes, I looked at the reference and also used the .csv extension.DoCmd.TransferText acExportDelim, , "Book", "C:\txtfiles\April.csv", True
1. You asked to export a .csv file NOT a .doc file.
2. Did you look at the reference Galzxiom provided?
Yes, I simply copied it and changed the table name. No file was transfered.Did you notice that your transfertext expression is incorrect? Did you try the one I provided?
You said the table name was "Book". Why did you change it? I see you also changed the path. Did the path you were trying to write to with the TransferText method exist?Yes, I simply copied it and changed the table name. No file was transfered.
DoCmd.TransferText acExportDelim, , "tbl_Tradeshift", "C:\tbl_Tradeshift_CSV" & ".csv", True
DoCmd.TransferText acExportDelim, , "My_Query", "MyPathFileName"