flexile

Open full view…

Export Whole Database

hval01
Mon, 12 Aug 2019 10:39:13 GMT

I am interested in being able to export a complete database as a CSV file. To complicate matters the database comprises multiple tables, some that are linked on a one to many relationship. I have six tables (Type_10, Type_29, Type_51, Type_52, Type_53 and Type_99. For the Type_10 Table there is only one record. This is the same for the Type_29 and Type_99 tables. The Type_51 Table has a one to many relationship with the Type_52 Table and also with the Type_53 Table. All text entries need to be exported with inverted commas around them. Finally, I wish to export all the data, in a certain order (same as above). The Type 51, 52 and 53 records all go in order an increasing number (like a line number) is added at a certain position within the CSV file. Is this feasible?

hval01
Mon, 12 Aug 2019 11:15:59 GMT

Apologies. I have posted in incorrect forum. How do I move this posting to the correct forum?