Hi
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, Dob, Phone Number etc and all the data from the remaining forms falls under these headings.
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. Ive 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.
DoB: 01/01/1990
Phone Number: 07773338888
Email: Something@email.com
Date of Incident: 13/01/2021
Accident Type: text here
Accident Circumstances: Lots of text here.
Injury Type: text here
Expert Type: text here
GP:
Hospital: somewhere General Hospital
Liability: text here
Translator Required?: text
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, Dob, Phone Number etc and all the data from the remaining forms falls under these headings.
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. Ive 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.
DoB: 01/01/1990
Phone Number: 07773338888
Email: Something@email.com
Date of Incident: 13/01/2021
Accident Type: text here
Accident Circumstances: Lots of text here.
Injury Type: text here
Expert Type: text here
GP:
Hospital: somewhere General Hospital
Liability: text here
Translator Required?: text