Table To CSV

[ceaser]

Hi All

I have a SQLite file called say "Job1". In "Job1" I have many tables....i.e horizontal alignment, vertical alignment, crossfalls, surface widths, Kerb Line, etc.

I would like to export all of these tables to one "csv" file. At the moment the tables override the data that is in the "csv" already.:sign0148:

Please hilfe:sign0085:

Thanks
Michael

 

[Cableguy]

Use a hidden table and append ALL the values to it, by going one table at a time, and copying each row..
Or you can easelly use the command from sql to append the data to this table...
Then export this hidden table to csv...

 

[ceaser]

Hi Cableguy

Thanks for your reply. I did try what you have mentioned with the sql command before, but the problem is that each Table has a different number of columns....ie. Horizontal Alignment(YCoord, XCoord, Radius, TransitionIn, TransitionOut), Vertical Alignment(Stakevalue, VPILevel, Length1, Length2), Local Coord File(Point Name, YCoord, XCoord, ZCoord, Decription)....etc.

Any other ideas?:sign0085:

Thanks
Michael

 

[Cableguy]

YES, One other possibility is to export each table to csv, and the load them and merge into a single file...

 

[Erel]

Are these tables with exactly the same columns?

 

[ceaser]

Hi Erel

No. Each Table has different number of columns.

regards
Michael

 

[Erel]

So what will be structure of the merged CSV file?

You should look for the sql UNION command to create a query that returns data from several tables.