Import or Export

[Eric]

I have a Word Template (Form Fields) that I currently export out to my Access
Database. The Form Fields are bookmarked and coincide with fields that I
have in the Access Database.

Which is better, Exporting from Word or importing from Access. Can you
import directly from a Word Template (Form Fields) without exporting to a
coma delimited txt file 1st.

If you can import from a Word Template, can you import only specific
identified form fields / (bookmarked) fields into specific tables?

I look forward to this discussion..... Thanks

 

[pietlinden]

I have a Word Template (Form Fields) that I currently export out to my Access
Database.  The Form Fields are bookmarked and coincide with fields thatI
have in the Access Database.

Which is better, Exporting from Word or importing from Access.  Can you
import directly from a Word Template (Form Fields) without exporting to a
coma delimited txt file 1st.

If you can import from a Word Template, can you import only specific
identified form fields / (bookmarked) fields into specific tables?

I look forward to this discussion..... Thanks

I would say exporting out of Access because you have more control
over the data.
You can import from a Word template that has bookmarks. You would
just loop over the bookmarks and write them to fields in a new record
in your table.

 

[Eric]

What about importing a template into Access. Does it matter, are there any
benefits to import into Access or Export from Word into Access?

 

[RD]

I have a Word Template (Form Fields) that I currently export out to my Access
Database. The Form Fields are bookmarked and coincide with fields that I
have in the Access Database.

Which is better, Exporting from Word or importing from Access. Can you
import directly from a Word Template (Form Fields) without exporting to a
coma delimited txt file 1st.

If you can import from a Word Template, can you import only specific
identified form fields / (bookmarked) fields into specific tables?

I look forward to this discussion..... Thanks

This is more of a business process question than a programming one.
The answer, IMO, is what works best for your process? I have an
application that imports data from Word forms because most of the
"work" is happenning in Access. If my database just sat there like a
bucket and didn't do any work it would make more sense to export from
Word.

And yes, you can import specific fields into specific tables.

HTH,
RD

 

[Eric]

Thanks RD, I'll look into IMO. Both the Template and Access are rocking with
users all the time. There is plenty of work being done in both.

Doug from MVP, helped me with pulling specific fields into specific tables.
I think for now I'll stick with exporting from word.