Exporting a table into Access2003.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have Word/Access2003.

With a scanner I have successfully converted
a table in a book into a table in Word2003.

I want to transfer this Word2003 table into a
table in Access2003.

Please help, Frank
 
Hi Frank,
I have Word/Access2003.

With a scanner I have successfully converted
a table in a book into a table in Word2003.

I want to transfer this Word2003 table into a
table in Access2003.
Click to expand...
Select the table. Table/Convert/Table to Text. Save as a
plain text file (make sure there's nothing else in the
document!). The result will be a standard delimited text
file which Access should be able to import.

Caveat: if the table cells contain paragraph marks you'll
need to remove them (or replace them with something else)
before converting to text. The record delimiter is a
paragraph and you can't change that.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Thank you. I figured it out, but there is
one annoying problem.

The table I have scanned from the book fills
the page in an up/down mode thought there is
still only two columns to the table.

Access2003 thinks that there are as many
fields as there are columns on the page.

How do I fix this? The scan comes out as a
RTF table in Word2003 with many columns, so
how do I get an only-two column table from
many? Cutting the extra columns and trying
to paste them to the first two does not work.

Regards, Frank
 
Hi Frank,
The table I have scanned from the book fills
the page in an up/down mode thought there is
still only two columns to the table.

Access2003 thinks that there are as many
fields as there are columns on the page.

How do I fix this? The scan comes out as a
RTF table in Word2003 with many columns, so
how do I get an only-two column table from
many? Cutting the extra columns and trying
to paste them to the first two does not work.
Click to expand...
If the scan gives you a table with many columns, then
you're going to need to do some work to break it down.
Please describe how "cutting the extra columns and trying
to paste them to the first two" doesn't work. The term
"doesn't work" is much too general to give us an idea what
could help...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Back
Top