sql - Bulk insert 0 rows inserted -

-

im trying use following statement in sql insert data csv sql..

create table test (a bigint, b smallint, c real, d real, e real, f real, g real, h real, real, j real, k real, l real, m real, n real, o real, p real, q varchar(max), r varchar(max))  bulk insert test 'c:\datafiles\tests.csv' (fieldterminator = ',',  rowterminator = '\n',   firstrow = 2 )

my data looks like:

"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r" "900010000000257","46","580.29","1912.31","237.73","841.41",,,"253.35","995.30","225.38","2808.70","1536.87","2250.60","1628.19","111.91",, "900010000000425","46","1580.29","1912.31","252.34","2557.97",,,"1256.35","195.30","225.38","208.70","1534.50","222.80","1628.19","284.23",, "900010000000841","21","489.26","5462.95","6419.69","7353.56",,,"467.70","535.01","597.93","530.84","5243.47","589.86","5790.72","6794.30",, "900010000000990","19","4880.14","5609.45","6586.67","7470.17",,,"480.14","523.12","558.16","655.44","504.21","609.54","639.31","735.34",,

i message 0 rows affected no errors.. please help.

try providing full specified path c:\path.csv


Comments

Post a Comment

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

-
i plot number of emails in inbox on time using gmail api , i'm seeing lot of drop-outs, whatever reason i'm getting incomplete count of messages @ single time points. my plots here: https://plot.ly/~tdsmith/2 -- "drop-outs" i'm complaining trace shoots downwards , recovers previous level @ next timepoint. the code i'm using count emails here: https://github.com/tdsmith/gmail-plotly/blob/master/gmail-plotly.py#l47-l64 what can diagnose these faults?
Read more

Installing Android SQLite Asset Helper -

-
i need use ready made database. search solution on internet did not work until decided use mentioned library found here . however, found hard use library in installation procedures shallow beginners. i appreciate step step procedure on how use android studio. in struggle tried copying sources main/libs , adding line gradle did not work. use api 19 if helps. update here build.gradle // top-level build file can add configuration options common sub-projects/modules. buildscript { repositories { mavencentral() } dependencies { classpath 'com.android.tools.build:gradle:0.11.+' compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' // note: not place application dependencies here; belong // in individual module build.gradle files } } allprojects { repositories { mavencentral() } } trying compile project error error:(9, 0) no signature of method: org.gradle.api.internal.artifacts
Read more

Qt Creator - Searching files with Locator including folder -

-
one quick question qtcreator : know possible use locator open files using "ctrl-k" shortcut. however, possible search files including locations? for example, let's want locate file named "main.cpp" in folder named "myfolder" , have lots of other main.cpp files. what should type locator in order open ? just type myfolder/main.cpp in locator
Read more