Hi
I have database 1 that I query to post to db2. Db1 has say 26 columns (with header row the same name as db2) and there are say 20 columns I want to upload to db2. Db2 contains the same (as the 20) but also additional columns in a different order (so different columns inbetween) and db2 is also used for different purposes so the upload from db1 is just one data source, so I want the db1 to create new rows (when applicable - there may only be 1 to 2 rows added per week) without it importing those rows as a table. So upon refresh I want a row of data to appear on the next blank row in another database, and then I can fill in the blanks/additional fields or questions that that database needs. So effectively a type of merge.
Also to note that db1 is also itself a query that pulls from another db(0) which itself captures data from db-1(which is overwritten daily).
Is the approach to do this to run a macro that looks in db1 finds any item tagged as 'new' find the issue ID number from that row and put it in the issue ID column (next available row) then refresh the query which will now find the relationship connection and upload all the other data as well as when any data in both db1 and 2 changes? In which case does anyone have any ideas for the vba to do this? thanks
I have database 1 that I query to post to db2. Db1 has say 26 columns (with header row the same name as db2) and there are say 20 columns I want to upload to db2. Db2 contains the same (as the 20) but also additional columns in a different order (so different columns inbetween) and db2 is also used for different purposes so the upload from db1 is just one data source, so I want the db1 to create new rows (when applicable - there may only be 1 to 2 rows added per week) without it importing those rows as a table. So upon refresh I want a row of data to appear on the next blank row in another database, and then I can fill in the blanks/additional fields or questions that that database needs. So effectively a type of merge.
Also to note that db1 is also itself a query that pulls from another db(0) which itself captures data from db-1(which is overwritten daily).
Is the approach to do this to run a macro that looks in db1 finds any item tagged as 'new' find the issue ID number from that row and put it in the issue ID column (next available row) then refresh the query which will now find the relationship connection and upload all the other data as well as when any data in both db1 and 2 changes? In which case does anyone have any ideas for the vba to do this? thanks
