Importing a WORD table into Access

[wdc202]

How can I import a Word table (6 columns by 800 rows) into a new Access database? Thanks.

 

[KeithG]

The easiest way would be to copy it to a spreadsheet and import the spreadsheet. You could use vba to open of the word doc and process the data row by row.

 

[GaryPanic]

you will lose all formating doing this - any bolding etc will go pear shaped

same with tabs they wil show up as iiiii - so be careful...

regards

 

[wdc202]

KeithG and GaryPanic: Thank you, very belatedly, for your responses to my years-old query. I missed them at the time and never got back to that issue.

But it has arisen again and i would value your advice.

I am building an Access data base that involves collecting data from many remote volunteers, most of whom do not have Access on their pcs. Is there another program they can use (maybe WORD or Excel) to enter the data and then send to me that I could then enter into the Access database on my pc?

Thank you. ...wdc

 

[wdc202]

KeithG and GaryPanic: Please`accept my apologies for not responding years ago to a post that you answered. I missed your responses at the time and did not find them until today. Very sorry. I hope you will look at my new query on a related topic "DATA ENTRY."

 

[GaryPanic]

If you send them a xls that has all of the fields required then you can import into access and have access do its stuff .

for gods sake don't use word - it will mess you up - and if Access goes tits up you should still be able to mess around with xls