Thank you in advance for I know not what I'm doing.
I have a current access 2013 database which is doing fine, however I'd like to proceed with better automation. I have access to online information which I would like to incorporate into my database's existing tables. The external database includes about 60 fields and thousands of records. I might like to incorporate say 20 fields into my existing table or tables. The external database's fields have different names and maybe different data types compared with my database. Also, the external database information is updated roughly 2 to 3 times a month, so this will be a regular update process.
I'm looking for a general direction to proceed first, then maybe more specific questions later. Should I go with maybe an append query? maybe a make table change? maybe an update?
Thank you so much for your expertise, H
data
I have a current access 2013 database which is doing fine, however I'd like to proceed with better automation. I have access to online information which I would like to incorporate into my database's existing tables. The external database includes about 60 fields and thousands of records. I might like to incorporate say 20 fields into my existing table or tables. The external database's fields have different names and maybe different data types compared with my database. Also, the external database information is updated roughly 2 to 3 times a month, so this will be a regular update process.
I'm looking for a general direction to proceed first, then maybe more specific questions later. Should I go with maybe an append query? maybe a make table change? maybe an update?
Thank you so much for your expertise, H
