Another Table Conversion question

[DanS]

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

 

[Doug Robbins - Word MVP]

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


--
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

 

[DanS]

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

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.