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?