Merge tables.

[Lee Weaver]

I have 2 tables, 1 contains a document number and several fields, and the other contains the document number and about 40 other fields.

I want to merge the 2 tables so all the information is in 1 table.

I have googled this but only seem to find cases where both tables contain the same fields.

Lee

 

[rainman89]

you can do a make table query linking the document ids and pulling all information from both, but why do you want them as one?

 

[Lee Weaver]

why merge.

I want them merged to make it easier for the vba for the project. the porject is rather complex and having to deal with multiple tables complicates things further. the data is archival data, that I have imported from multiple sources. after the new system goes live all the information will be gathered by a single form.

 

[rainman89]

I want them merged to make it easier for the vba for the project. the porject is rather complex and having to deal with multiple tables complicates things further. the data is archival data, that I have imported from multiple sources. after the new system goes live all the information will be gathered by a single form.

ok well do the make table query then. Its your best bet.

 

[Lee Weaver]

make table query

I'm attempting to at this time. will post again if I have more questions. Thanks for the Information

 

[Lee Weaver]

this is going to take some work.

I am unable to do a merge in this way because I am changing field types in the new database. some of the fields are LONG text fields, and I am making them embedded word documents, so I will have to figure out how to do this via VBA. So the question now morphs to:

How do I write data to an embedded ole object word document in an access field via VBA?

Starting new thread.