save a space delimited file into a streammode via excel

T

TBK

Hi

I had a user requirement to save a space delimited file into a streammode file via excel

Streammode means read a file into 32K chunks, the carriage return is only at the last record, instead of every record in each line

Would appreciate if someone can kindly advise whether it can be done in excel, or we need to do programming to convert the file into stream mode

Thanks & regards
TBK
 

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

Similar Threads

Lost columns in formated text (space delimited) save 10
How can I save a 40meg 26,000 row file to Space Delimited format 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Problem encountered when saving worksheet as a text file 3
Using ~ as a delimiter for Excel file saves 2
When saving Excel as a txt too many spaces are introduced. 0
create fixed length cells & rows in excel as space delimited .prn 1
Saving txt files with quotation mark delimiters 2

Top