[vicsireland] Re: MSWord Question
- From: "Cearbhall E. O Meadhra" <cearbhall.omeadhra@xxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 8 Jun 2006 18:14:07 +0100
Dear Tony,
The simplest way to do this is to
* highlight the area of the table with ctrl-shift down-arrow;
* copy to clipboard
* open notepad
* paste from the clipboard into a new notepad file
(you will see that you have now created a tab deliminated text table)
* using ctrl-h change all the tabs into commas
(This converts the tab-deliminated file into a comma separated text file)
* save the text file.
All the best,
Cearbhall
"Good design enables - Bad design disables"
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Sandberg, Robert
Sent: 07 June 2006 16:12
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: MSWord Question
Hi Tony!
It should be possible to select the Word table and copy and paste it into an
empty Excel sheet.
Of course some columns may have to be formatted, according to the values
they contain, such as dates.
If for some reason that doesn't work, I'd write a VBA routine in Access.
Import the Word table into an Access table and either create a module that
copy's the data cell by cell - or create an SQL query in which you can
insert the commas as text and then just let the module bung it into a Word
document. Actually, the latter is by far the easier way.
Cheers,
Robbie Sandberg
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Murray
Sent: Mittwoch, 7. Juni 2006 15:20
To: VICS
Subject: [vicsireland] MSWord Question
Hi VICSonians,
I've a table in MSWord, which I want to export to a CSV file. CSV (Comma
Separated Value) files are just flat text files delimited by commas.
Now,
if I can get it in to MS Excel, I can save it out as a CSV so that'll do.
Does anyone know of a way of getting my table from MSWord in to MSExcel?
If not that, does anyone know of a way of converting the MSWord table in to
a CSV?
I don't fancy manually copying and pasting each cell... The table is
massive!
It's ironic really... I've been given an 83 page functional spec, and all I
need is this one table. Someone actually went to the bother of pulling the
contents of a table from the Mainframe and converting it in to MSWord as
part of the spec. Now I want to take it back out of Word and make it in to
flat text... which is the format it would've come from the Mainframe in
originally.
Am I rambling? Yes. The Sun is having some weird effects on me. It's
making me want to drink beer on Wednesdays, and forget work.
Can anyone help me?
Tony
"If something is too hard to do, then it's not worth doing. You just stick
that guitar in the closet next to your shortwave radio, your karate outfit
and your unicycle and we'll go inside and watch TV."
--Homer J. Simpson
************************************************************************
********
This document is strictly confidential and is intended for use by the
addressee unless otherwise indicated.
This email has been scanned by an external Email Security System.
Allied Irish Banks
************************************************************************
********
Other related posts: