Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

insert a missing value in a numeric field

Discussion in 'Information Technology' started by shailesh.tewari@gmail.com, Jul 28, 2006.

  1. shailesh.tewari@gmail.com

    shailesh.tewari@gmail.com
    Expand Collapse
    Guest

    I want to insert a csv file in an access database.For some numeric
    fields I am geting missing values in csv file.How can I insert a
    missing value in the access.I do not want to insert 0(zero) and it is
    not allowing me to save ' ' ( which becomes string).

    Any quick code /solution??
     
  2. Loading...

    Similar Threads Forum Date
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Heritage The curious case of Maharaja's 'missing' painting History of Sikhism Oct 29, 2013
    India Half of the missing children in 2013 remain untraced in India Breaking News Sep 3, 2013
    Note to admin: Missing post Literature Jul 7, 2013
    Malaysia Missing woman found dead Breaking News Jul 3, 2013

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    shailesh.tewari@gmail.com wrote:
    > I want to insert a csv file in an access database.For some numeric
    > fields I am geting missing values in csv file.How can I insert a
    > missing value in the access.I do not want to insert 0(zero) and it is
    > not allowing me to save ' ' ( which becomes string).
    >
    > Any quick code /solution??


    Well numeric values run from - infinity to zero to + infinity. Take you
    choice.

    I suspect you want to use null. so the value will be blank, but not
    zero. Is that correct?

    --
    Joseph Meehan

    Dia duit
     
  4. shailesh.tewari@gmail.com

    shailesh.tewari@gmail.com
    Expand Collapse
    Guest

    You are correct.I want to insert null .How?
     

Share This Page