Merge data from another Access file

[Hdata]

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, Hdata

 

[pbaldy]

In general terms, you'd use an append query to add new records to your tables(s), an update query to modify existing records. That assumes you can link to the external databaase and use its table(s) as a source. You may be able to handle data type differences in the queries using conversion functions like CStr().

 

[Hdata]

Thanks Paul

 

[pbaldy]

No problem. Post back if you get stuck in the details.