How would could this be done

[josie]

We have a word document that lists, in a column, various countries.

What we would like to be able to do is inport each country, as a seperate
record, into a table.

Is this possible, if so any suggestions on how would be appreciated

Using Access & Word 2002

Thanks in advance

josie

 

[Ken Snell [MVP]]

Is this a one-time import, or something that you'd do over and over?

 

[josie]

Ken

It would be a one-off import

josie

Is this a one-time import, or something that you'd do over and over?

 

[Ken Snell [MVP]]

One time? Then I wouldn't mess around with any specific importing setup. I'd
be inclined to create a table with two fields: PrimKey (autonumber field),
and fldCountry. Open that table in datasheet view.

Highlight all the country cells in the Word document's table. Copy those
cells (Ctrl+c).

Put the cursor on the left border of the fldCountry field in the table's
datasheet view -- when the cursor change to a "cross", then do Ctrl+v to
paste the values. The autonumber field will fill in automatically.

You now can manipulate the data from this table by appending it to another
table if you wish.
--

Ken Snell
<MS ACCESS MVP>