"Conan Kelly" CTBarbarin at msn dot com wrote:
How do I open a text file in MS Word so that it is not bound to a paper size or margins?

I have a text file that I need to import into MS Access/SQL Server.
This text file runs out to column 174 in Notepad (when Word
Wrap is shut off). But this text file is in a "Report" format:
every 57 lines is the page header for the next page and then
records follow. That is why I want to open it in Word, so I can
run macros on it to delete the page headers and the summaries at
the end of each section so I can import only records into Access/SQL Server.

When ever I open it in Word, first the File Conversion dialog box pops up
with Unicode selected. I click "OK", but then the ruler
shows up at the top of the Word doc limited to 11.5" and the lines are wrapping
when it gets to the right margin. I've tried changing paper size and margins
but can't seem to get the 11.5" ruler to expand so the lines will quit wrapping
and each record will only take up one line.

I'm afraid of how that will affect my macros. They will depend heavily on
finding certain text and then deleting a certain number
of lines once that text is found. I would definitely be more comfortable
writing/running my macros if the lines did not wrap.

Hello,
don't bother if Word wraps the lines. This is just a display matter and
doesn't affect the file as long as it is saved as plaintext (or
Unicode).
Each end-of-line (actually an end-of-line + carriage-return pair) in a
plaintext file shows as paragraph mark when opened in Word; each
paragraph mark in Word becomes an end-of-line when saved as plaintext.

It also won't affect your macros as long as you don't rely on Word's
"lines" but rely on paragraphs.



--
email me: change "nospam" to "w.hennings"
Wilfried Hennings c./o.
Forschungszentrum (Research Center) Juelich GmbH, MUT
http://www.fz-juelich.de/mut/mut_home
All opinions mentioned are strictly my own, not my employer's.