how can i load csv file ?
Moderators: gto, cipto_kh, EgonHugeist
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
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
