Exporting Large Amounts of Data to a text file

[dbrunjes]

When I try to export results from a query (about 300,00 rows)to a .txt file in ACCESS 2007, I get an error message that the clip board can exceed 64 rows.

Is there a way of getting around this?

Thanks

[ADezii]

You can manually Export the Data (Comma Delimited) using VBA Code. Post the SQL for the Query so that we can have a look.

[NeoPa]

What method are you using in your attempt to export the data?

In whichever method that is, are you sure it is 64 rows rather than 64K?