LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 557
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to XML is not exporting all records Eagle_Fan Excel Discussion (Misc queries) 0 February 23rd 10 09:33 PM
Export records into a text file based on criteria Maver1ck666 Excel Programming 6 January 8th 08 03:17 PM
how do I export excel records to csv file? 39steps Excel Discussion (Misc queries) 2 August 1st 07 01:34 PM
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet divya Excel Programming 1 October 26th 06 12:12 PM
How do I export an excel file as fixed length records iainjh Excel Discussion (Misc queries) 2 March 3rd 05 05:59 PM


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"