Error on TransferText method

[marnieg]

I am just trying to export the contents of a table to a csv file. Here is my command.

DoCmd.TransferText acExportDelim, "ballotdist", "BallotDistribution", ballotdist.csv, True

The "ballotdist" is my specification file and "BallotDistribution" is my table name. I want all the data for this table to a csv file. I am getting an error message on the execution of this statement that just says "Object Required"

I want to be able to allow a user to edit this file in Excel and then I will read it to update the database with the changes they have made.

Thanks for any suggestions!

 

[marnieg]

I figured out my problem. I needed my export filename in a path with quotes.