I wondered if someone could help me.

I have set up the following code to export results from query "addresses" to a .csv file, but receive a Compile Error.

Private Sub Command6_Click()

DoCmd.TransferText acExportDelim, "Addresses",
"thecsvfile.csv",True

End Sub

You need to specify a path to the file.

DoCmd.TransferText acExportDelim, "Addresses", "C:\thecsvfile.csv",True

HTH



mmcdonal

Hi there. I have tried this code and it gives me a debug error stating that ... the test file "marketing" does not exist, This is the query i want it to run, would i need to create a text file?


DoCmd.TransferText acExportDelim, "Marketing", "C:\Act.csv",True

Can anyone shed some light on this, as it doesnt seem to run the query i have made :(

Thanks

I think the error you are getting is that the database can't find the object "Marketing". Is there a query or table with this name in the database?


mmcdonal

I changed "Marketing" to "Act Query" which represents a query that i have made within the database. It still comes back with the same error. Even though the query is working?

Allan

Please note the exact syntax here:

DoCmd.TransferText acExportDelim, , "tblTableOrQueryName", "C:\FileName.csv"

mmcdonal

That worked a treat, thank you.

I have it working so that when you check a check field it sends it to the csv, is there any way i can reset the check field after sending?

Thanks

You could run a query that will do this... Either calling a saved query, or running some SQL from VBA - "UPDATE myTableName SET checkBoxColumn = 0"

Mike

Mike
EchoVue.com

If the form is not closed, you could probably also reset the check box by setting the value to 0.

I would be careful since the user may check the box, then watch it unchceck, and then keep trying to check it again and again. Why not put this on a button on click event. Also, you could have a message box pop up to tell the user the file has been created successfully (If err = 0).



mmcdonal