actually it does, for some reason the syntax error is in the the sql ,
I tried encasing with single quotes , double quotes , nothing is working, i
keep getting the same stupid error
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax err
oh, actually it doesnt work if there are some null values in the list:
heres a samle list that causes an error:
LAMVEN EAST OFFICE
LAM,VTT,,,
how can i solve this problem?
At 06:33 AM 3/26/2002 -0600, you wrote:
>Richard,
>
>Check your insert statement for proper use of quotes. Whenever
ok im gonna show you my code, im trying to upload a comma delimited file to
a database , seems to work in most situtiions, except when im working with
this one file that has 28 fields, the insert statement shows a syntax
error, if i shrink the same csv file to 5 fields, no errors happen, im
tr