If each record of your WORD Document occupies just 1 line with a
paragraph return at the end of each line and you have a "fixed" length
for each field then you can copy and paste directly into EXCEL and then
"split the text into the applicable number of fields in EXCEL. To see if
your "text" lines up into equally spaced fields - apply the COURIER
font. Select your report and then paste it into Column A. Once the
report is in Excel. Select the column usually column A - then select
DATA - Text To Columns and follow the instruction on the popup menu to
split the text into individual columns. If you can have your database
generate a report as "CSV" or "TABBED" records, then you can import
directly into EXCEL.
If your database generates a report as a WORD table - then copy and
paste the table directly into EXCEL. But for the information to lineup
correctly you need to remove all of the following: Any paragraph marks,
tab marks and manual line breaks and replace them with a single space.
To do this - in WORD select find and replace - select the MORE button -
then select Special and then in the select paragraph marks, tab marks
and manual line breaks (one at a time) and then in the replace box -
just hit the space bar 1 time and the above items will be replaced. For
anymore information info on the conversion - I would need to see what
the report looks like.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498035