Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
djn
 
Posts: n/a
Default Excel and Delimited File

I want to move a large text file into Excel. I had thought about sending it
to the mainframe to put delimiters in and then reship it to Excel. However
the file is so large I can't send the file to the mainframe. Is there a way
the file can be broken down into pieces? Or is there an easy way to get the
file delimited in Excel w/o sending it to the mainframe? Thanks so much.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If that file is too large for the mainframe, I would guess that it's way too
large for excel.

But if the data is laid out nicely, maybe just using fixed width file format
would be sufficient.

Another option would be to use your favorite text editor (wordpad???) to break
the file into smaller pieces.



djn wrote:

I want to move a large text file into Excel. I had thought about sending it
to the mainframe to put delimiters in and then reship it to Excel. However
the file is so large I can't send the file to the mainframe. Is there a way
the file can be broken down into pieces? Or is there an easy way to get the
file delimited in Excel w/o sending it to the mainframe? Thanks so much.


--

Dave Peterson
Reply
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
Converting Excel data into semicolon delimited text file danmcgov Excel Discussion (Misc queries) 1 April 14th 05 04:30 PM
Export excel file to semicolon delimited text file capitan Excel Discussion (Misc queries) 5 April 7th 05 03:06 AM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 04:19 AM
saving excel file as tab delimited Craig Hilliard Excel Discussion (Misc queries) 0 February 1st 05 10:39 PM
save an Excel worksheet as a comma delimited file? Trophy Man Excel Discussion (Misc queries) 2 January 8th 05 03:11 AM


All times are GMT +1. The time now is 02:42 AM.

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"