Urgent! csv > sqlite > process > csv

Beja

Expert

Licensed User

Longtime User

• Mar 12, 2014

• #1

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

Expert

Licensed User

Longtime User

• Mar 12, 2014

• #2

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

Expert

Licensed User

Longtime User

• Mar 12, 2014

• #3

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

Click to expand...

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

Active Member

Licensed User

Longtime User

• Mar 14, 2014

• #4

How many fields are in your csv file?

 

Beja

Expert

Licensed User

Longtime User

• Mar 14, 2014

• #5

Ten

 

Beja

Expert

Licensed User

Longtime User

• Mar 17, 2014

• #6

This offer is closed.