Hi all, need to extract large amounts of info from my database of results etc, heaps of records, as you know Aus racing prolific. So, here's my query:

I am using the export feature in Query in Access, to export a large quantity of info to a text file. Is there any way for Access to automatically break it up into smaller files instead of sending it to one large text file?

Preferably, I'd like it to be able to break it up into month by month files - there's three years worth of data (starting 2003) so it'd have a Jan 03, Feb 03 etc.

Is this possible, or is there any other way to get Access to export to a number of files, rather than just one?

Another way might be to limit it to say 5,000 records per text file perhaps?