johnbornsworth
New member
- Local time
- Yesterday, 17:46
- Joined
- Oct 29, 2019
- Messages
- 5
Hello there! I would like to import data from an old cloud database of ours (Podio) into a new MS Access database we've developed. Problem is the Access app has more tables than Podio and that's over my head. A easy example is Contact Types. In the exported Excel sheet from Podio we have a flat file, contact name, address, type. Then in Access we have contact name, address and a foreign key (precise word?) for contact type who's data we store in another table (ContactType).
Another example is my excel sheet has a "Created by" field, which is derived from my employees. The Access database Contact table pulls this "Created by" information from an Employees table. All that's stored in the Access Contacts table for who created the record is a number, related to the employee.
So how can I import these excel records into two tables, not just one? Can I perform this with a well-made append query?
John Born
Tree Detective
Another example is my excel sheet has a "Created by" field, which is derived from my employees. The Access database Contact table pulls this "Created by" information from an Employees table. All that's stored in the Access Contacts table for who created the record is a number, related to the employee.
So how can I import these excel records into two tables, not just one? Can I perform this with a well-made append query?
John Born
Tree Detective
Last edited: