Hi! I copied the SQLite administrator, and would to import a csv file to my DB tables.
the files contain text qualifiers. like (").:
"12345678","00000000","Some text"
"12345678","00000000","another text"
"98765432","00000000","and again new text"
so I created 1 table with 3 fileds . 2 numeric and 1 varchar
and I used Data importer tool from administrator.
and after import opperation, the values in first two columns weren't displayed.
if I edit the table and change the fileds to be varchar .. and values are displayed..
How can I force to import a character value to be numeric as in my case?
SQLite Administrator
Moderators: gto, EgonHugeist, Orbmu2k
ok. get an emptuy database and it's ok, .. I think the check box (clear table before import) on import Data dialog doesn't work properly.. because when I made changes I already got data imported as varchar, then I changed the column type to numeric, and normaly the values weren't displayed, then perform once again an import opperaton and tick "Clear table before import".. then I got empty columns..
also . the import opperation is very slow,
it takes about 20 min for 16k rows..
the same table is importer much more faster in MS Access DB ..
Tnx.
aslo, when importing is finished no message are displayed .. just a progress bar iz completed, but who knows if the import is just finished or have to finish in a while..
also . the import opperation is very slow,
it takes about 20 min for 16k rows..
the same table is importer much more faster in MS Access DB ..
Tnx.
aslo, when importing is finished no message are displayed .. just a progress bar iz completed, but who knows if the import is just finished or have to finish in a while..
Last edited by zdragon on 24.02.2006, 13:51, edited 1 time in total.
in the test session yesterday, i always had clear table checkbox checked ... if the checkbox is checked, only a "delete from table" statement is executed before import.
You got right, the speed of the import is very slowly.
But I have imported 100k rows in 5min on a P4 3,2 HT
The import feature is just a quick implementation, only a "nice to have" feature.
If you often import external data its better to code your own import, based on your special data structure or any datasource.
You got right, the speed of the import is very slowly.
But I have imported 100k rows in 5min on a P4 3,2 HT
The import feature is just a quick implementation, only a "nice to have" feature.
If you often import external data its better to code your own import, based on your special data structure or any datasource.