Prev: Auto Increment by 1 Letter
Next: Error 2147352567
From: K on 28 May 2010 04:30
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
below)

Data 1.txt
Data 2.txt
Data 3.txt
etc…..

I'll be very greatful if any friend can help me on this as I am
struggling on this.
From: Tom van Stiphout on 28 May 2010 10:13
On Fri, 28 May 2010 01:30:05 -0700 (PDT), K <kamranr1982(a)yahoo.co.uk>
wrote:

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

-Tom.
Microsoft Access MVP


>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
>below)
>
>Data 1.txt
>Data 2.txt
>Data 3.txt
>etc�..
>
>I'll be very greatful if any friend can help me on this as I am
>struggling on this.
 | 
Pages: 1
Prev: Auto Increment by 1 Letter
Next: Error 2147352567