Hi
I'm new to this website and have been advised to move my question to the VBA forum from Access. I tried to insert the link
but then could not post the thread so removed it.
Sorry about this but I am new to VBA, I know a bit but stuck on how to do this - so if anybody could help me with this please.
I have hundreds of forms as MS Word documents in the format below and would like to import them into Access.
So that the data in each form comes under one common field heading, so for example, there will be one top row in excel with
titles, Date of Birth, Phone Number etc. and all the data from the remaining forms falls under these headings. The original document doesn't contain
fields for entering , text input is just typed after the colon.
I am thinking, it may be that I create a table of this in Excel first and then pull this into Access
Is it possible to do something like this? are there similar examples somewhere I can view?
Thanks for any help. I've been doing it all manually at the moment copying and pasting so it would be great if
there was some way of speeding this up.
I'm new to this website and have been advised to move my question to the VBA forum from Access. I tried to insert the link
but then could not post the thread so removed it.
Sorry about this but I am new to VBA, I know a bit but stuck on how to do this - so if anybody could help me with this please.
I have hundreds of forms as MS Word documents in the format below and would like to import them into Access.
So that the data in each form comes under one common field heading, so for example, there will be one top row in excel with
titles, Date of Birth, Phone Number etc. and all the data from the remaining forms falls under these headings. The original document doesn't contain
fields for entering , text input is just typed after the colon.
I am thinking, it may be that I create a table of this in Excel first and then pull this into Access
Is it possible to do something like this? are there similar examples somewhere I can view?
Thanks for any help. I've been doing it all manually at the moment copying and pasting so it would be great if
there was some way of speeding this up.