• kent
  • Member
  • Offline
  • Registered: 2015-12-04
  • Posts: 13

Topic: Textfile to table with Relationship to 2 dictionary tabeles.

Hi!
I want to import from a csv file to a table with 2 Ralationship. How do I do that?
Ex for the big table:
  - Name
  - Adress
  - Country
  - id_Class
  - id_Club

Dictionary table 1 (id_Club)
  - Name

Dictionary table 2 (id_Class)
  - Name


Thanks

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Textfile to table with Relationship to 2 dictionary tabeles.

Hello,


Please show me an example of your csv file.

Dmitry.
  • kent
  • Member
  • Offline
  • Registered: 2015-12-04
  • Posts: 13

Re: Textfile to table with Relationship to 2 dictionary tabeles.

Hi.

Here it come.

  • kent
  • Member
  • Offline
  • Registered: 2015-12-04
  • Posts: 13

Re: Textfile to table with Relationship to 2 dictionary tabeles.

Hi!

Here it come.

Post's attachments

Attachment icon Infile.csv 196 b, 446 downloads since 2016-02-19 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Textfile to table with Relationship to 2 dictionary tabeles.

Please check out an example
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.
  • kent
  • Member
  • Offline
  • Registered: 2015-12-04
  • Posts: 13

Re: Textfile to table with Relationship to 2 dictionary tabeles.

Thanks you.