Best way to import Many to Many relations between 2 tables "Companies" & "Categories"

General
5

Hello @William_Lee

If I understood the essence of your question correctly, then the best way to import tables with relations using MS Access is to create test data, for example:

  1. Create a Parent table
  2. Create table Child
  3. Add a one-to-many relationship from Parent to Child
  4. Add multiple objects
  5. Make export - Console - Manage - Export
  6. Download export zip
  7. View the structure of csv files that are in the export zip file.
  8. Fill these files with your data or create your own csv files by analogy.
  9. Pack new csv files into zip
  10. Make an import.

Perhaps you want to achieve something else, correct me, and I will be happy to help you.