Word97 doc as input to Access97 table

[docslime]

Hello Office experts,
I have a Word 97 document set up in two columns per page containing contact information for members of an organization. The data is set up like address labels with each bit of info on top of the next (name, address, phone, fax, etc.). I would like to take this data and enter it into an Access table for for queries, reports, etc. I'd rather not copy & paste the 300+ members info. Thanx for any help anyone can give me

docslime (technical user)

 

[SkipVought]

Hi,

Here's the work around, 'cuz Access does not recognize .doc as a data source (most of the time its just text -- give 'em a break!)

1. Open Excel
2. Select the table in you document (I assume that your table has headings)
3. Copy
4. Go to Excel and paste into A1
5. Save your Excel workbook
6. Open Access/database
7. select menu item File/Get external data/Import...

This will take you thru verifying each column and attributes.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[TonyJollans]

Hi docslime,

Is your data in a Word Table, or is it just text? If just text it might need a bit of work but I have done something similar before - if you'ld like to post a bit more detail of the format I'll give it a try. If it's in a table already, of course, Skip has given you the answer.

Enjoy,
Tony

 

[docslime]

Thanks for your responses Skip and Tony,
The data is just two columns of text, not in a table ... If I need to massage the data in some way then so be it ... I just want to make sure I'm not missing a better way to get there from here.

docslime