Table To CSV

C

ceaser

Active Member
Licensed User
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

Expert
Licensed User
Longtime User
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...
 
C

ceaser

Active Member
Licensed User
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

Expert
Licensed User
Longtime User
YES, One other possibility is to export each table to csv, and the load them and merge into a single file...
 
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…