[vicsireland] Re: MSWord Question
- From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Wed, 7 Jun 2006 17:11:59 +0200
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: