I have 2 separate databases that contain similar information but do not share the same field names. I would like to transfer specific fields, from one record at a time, to corresponding fields (with different names than the original) in the other database. 2 questions:
1. Should I use an ADODB connection?
2. What functions are available to transfer specific fields as described?
I am vaguely familiar with ADODB connections and could probably write the code for that but I am having a hard time finding the functions to do what I want once I open the connection. Thanks!
1. Should I use an ADODB connection?
2. What functions are available to transfer specific fields as described?
I am vaguely familiar with ADODB connections and could probably write the code for that but I am having a hard time finding the functions to do what I want once I open the connection. Thanks!