none
Changing format of nemmeric value from csv file to a table in access RRS feed

  • Question

  • Hi

    I would like to save a csv file ito a table in ms access:

    XValue, YValue, Wert, Name, FzgID , , "CARB (Evap Denom)", DIUMPR_CldStrtDenCldStrtTyp_C, 238 , , 800.0000000000000000, DIUMPR_ctGen.l500MD_C, 238 , , 10000.0000000000000000, DIUMPR_ctGen.l500MDInc_C, 238 , , 600.0000000000000000, DIUMPR_ctGen.nIgnMin_C, 238 , , 740.0000000000000000, DIUMPR_ctGen.pEnvMin_C, 238 , , 5.0048828125000000, DIUMPR_ctGen.rAPPMax_C, 238 , , 15.0024414062500000, DIUMPR_ctGen.rLdMin_C, 238 , , -6.6400000000000095, DIUMPR_ctGen.tEnvMin_C, 238


    but in access table the numeric values look like this:

    format of numeric values is changed, but I would like to have numeric values like what I have in csv file?

    what should I do to solve this problem?


    • Edited by babak.per Wednesday, June 18, 2014 9:06 AM
    Wednesday, June 18, 2014 7:40 AM