OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Database Design (http://www.officefrustration.com/forumdisplay.php?f=27)
-   -   Export Table Records to txt file (http://www.officefrustration.com/showthread.php?t=1118003)

K[_4_] May 28th, 2010 09:29 AM

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
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.


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
OfficeFrustration.com