Another Table Conversion question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DanS - 21 Dec 2006 02:19 GMT

Hi,

I have a word document that has a huge table on it that I would like to get
into an Access Database. Using Excel as a go between seems like it should
work.

I have tried just copy and paste into Excel, but for some reason, it
doesn't go properly.

The table consists of 3 columns.

Command Syntax Description

The Command and Syntax columns are fairly short length data, maybe 30 or 40
characters or less. The description column has some with no data, up to
some with what I'd estimate maybe 1.5k - 2k characters.

I've tried to just copy/paste of a single row for testing as well. What I
see in Excel is the first 2 columns inport properly, it seems, but the
third column seems to get broken into several vertical cells, like there's
a limit to the field length.

Unfortunatly, this document was converted from WordPerfect. Some of the
longer Decsription fields also have non-printable characters.

Short of either retyping or cut & pasting 100's of times, any suggestions ?

Thanks,

DanS

Reply to this Message

Doug Robbins - Word MVP - 21 Dec 2006 07:10 GMT

It may be better to ask in an Access Newsgroup.

There is no doubt however that it can be done using code that iterates
through the rows of the table.

The last in the following series of articles will give you an idea about how
to get data from Word into Access

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 29 lines]
>
> DanS

Reply to this Message

DanS - 21 Dec 2006 12:22 GMT

> It may be better to ask in an Access Newsgroup.
>
[quoted text clipped - 3 lines]
> The last in the following series of articles will give you an idea
> about how to get data from Word into Access

<SNIP>

> Part 5: Connect your AutoForm to a database to save input time and
> keep better records!
> http://www.computorcompanion.com/LPMArticle.asp?ID=136

Thanks, I'll take a look.

Reply to this Message