Exporting from Word to Access

[amjad171]

Hi,

I'm new to this forum and it's my first post, any help is greatly appreciated.

I have just been given a big project of firstly transferring information we hold in word documents over to Ms Access and then using ASP or .NET I got to make this a searchable, more user friendly web page displaying the information from the database.

I have tried searching on the web but have not found anything that can transfer information from a table in a word document to a table in Ms Access, does anyone know of anything out there that allows this to be done without losing any data in the transfer?

I have tried saving the document as a text file and importing it into Access but it did not transfer the data across correctly.

 

[spoole]

if saving the document as text and importing is not working then it would suggest that the tables in word are not in a "format" that access accepts. Remember importing tables in access requires that the table are absolutely consistent: every record must have the same number of columns (fields), each column must have compatible
data in every row (e.g. if you want a column in Word to become a numeric
field in Access, every cell in the column must contain either a number
or nothing, not even "-" or "n/a".)

Long story short I think you are going to have to re-arrange the tables in work to a format that is accepted.

 

[amjad171]

Thanks Spoole,

I guess its back to the drawing board, Is the only real option in that case to get someone to copy and paste from word to access?

Thanks

if saving the document as text and importing is not working then it would suggest that the tables in word are not in a "format" that access accepts. Remember importing tables in access requires that the table are absolutely consistent: every record must have the same number of columns (fields), each column must have compatible
data in every row (e.g. if you want a column in Word to become a numeric
field in Access, every cell in the column must contain either a number
or nothing, not even "-" or "n/a".)

Long story short I think you are going to have to re-arrange the tables in work to a format that is accepted.

 

[spoole]

either that or use the database to track the original word documents? so you would search for a document by title or catagory and it would give you a location i.e \\yourserver\wordfiles\word.doc. Then all you would need to do is place the original word documents on a shared drive and only need to maintain 1 table with fields: document_catagory, document_title, document_location. and a form to search by, although I think that may defeat the idea of the project