Urgent! csv > sqlite > process > csv

[Beja]

Hello guys,

This project is to convert csv to sqlite, select fewer columns and save the new table back to csv.
before saving, the table will be populated in Klaus's simple database example, by expanding the number of fields from just two to accommodate all of the table fields, after sorting them by a selected field.

details by pm.

 

[DonManfred]

Why to go first way to sqlite and then back to csv....
It could be easier to load csv, select columns you want to "hold" and then saving back the smaller csv.

 

[Beja]

Why to go first way to sqlite and then back to csv...

Thanks for the question.. I will be working on Klaus db example that uses sqlite.. but I need a copy of the csv for
another part of the system.. that part uses ms mdb database already and I don't want to brake the code there.

 

[Reviewnow]

How many fields are in your csv file?

 

[Beja]

Ten

 

[Beja]

This offer is closed.