Converting Excel to Space delimited - How beat the limits?

[mv5869]

Hi,

I have a spreadsheet that I am trying to convert to a space delimite
file, so that I can load it into a DB2 database.

The only way I can find to do this is to save the file as a spac
delimited *.prn file. However, for some reason Excel inserts a lin
break after every 241 characters. I need to find a way of exportin
long lines (up to around 1000 characters, spread across severa
columns) to a space delimited file without Excel inserting a line brea
until the end of the row.

Has anyone found a way around this?

Thanks for any help

 

[Jim Rech]

This article discusses the limitation and provides a macro workaround.

http://support.microsoft.com/default.aspx?scid=kb;en-us;249885

--
Jim Rech
Excel MVP
|
| Hi,
|
| I have a spreadsheet that I am trying to convert to a space delimited
| file, so that I can load it into a DB2 database.
|
| The only way I can find to do this is to save the file as a space
| delimited *.prn file. However, for some reason Excel inserts a line
| break after every 241 characters. I need to find a way of exporting
| long lines (up to around 1000 characters, spread across several
| columns) to a space delimited file without Excel inserting a line break
| until the end of the row.
|
| Has anyone found a way around this?
|
| Thanks for any help.
|
|
| --
| mv5869
| ------------------------------------------------------------------------
| mv5869's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=16470
| View this thread: http://www.excelforum.com/showthread.php?threadid=278243
|