how can i load csv file ?
Posted: 08.04.2009, 15:31
load data ?
Just the same way as you would do using any other TDataset dependent component. Parse the input lines and fill the fields one by one.
My hints:
1. find some third-party software that's specialised in loading csv into SQLite
2. search the internet there may be sample programs that do exactly this using the standard Delphi BDE based components. Normally you can just replace these components by TZQuery or TZTable.
3. check if sqliteadmin has a feature for this.
4. write a parser yourself. Use a TZQuery with sql 'select * from table'. Append a row. Fill the fields. Post the row. Read next row, ...
Mark