Export Table Records to txt file



Hi all, I have Table "T_Data" in my database. In "T_Data" I have
220000 records. I need to export them into txt files. I need some
kind of macro which should export chunk of 60000 records into one txt
file and save that file in folder called "Data" on "C:\" drive. Macro
should also put numbers at the end of each txt file name. Like (See

Data 1.txt
Data 2.txt
Data 3.txt

I'll be very greatful if any friend can help me on this as I am
struggling on this.

Tom van Stiphout

On Fri, 28 May 2010 01:30:05 -0700 (PDT), K <[email protected]>

Show us what you have so far, and we may be able to offer
How automated do you need this to be?

Microsoft Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question