Import - Microsoft Work

[121854]

Is there anyway to import and load a microsoft work document to a database? I have three or four reports that would like to load to access to produce year-end reports.

Suggestion, advise or how to will be appreciated.


Luis

 

[alvechurchdata]

What sort of document is it? Excel can read wks and Word can read wps and either can write them out as a more useful format.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[121854]

Thank you for your quickly replied. The document is a work document. When you said that wps, does that mean that I need to save the word document in that specific format. Then I can import the document to access. Not familiar with that format. I just want to keep the format (schema) of the document so that I can load data every month.

Hopefully that help. And thank you again for your collaboration.

 

[alvechurchdata]

The document is a work document

Microsoft Works stores different types of data in different types of file. If the file has a name like "myFile.wps" this it'll be from the Works' word processor and one of Word's options is to open this type of file. I'm afraid I don't know of a way of importing a Works document straight into Access.

Geoff Franklin

http://www.alvechurchdata.co.uk