tags:

views:

16

answers:

0

hi

i need to get data from .csv file to access

it works excellent but i have one problem.

when i try to get : IS-43"39"36"24

i receive: "IS-43""39""36""24"

some code:

while (SW.Peek() != -1)
                {
                    TEMP = (SW.ReadLine());
                    TEMP = TEMP.Replace("'", " ");
                    char[] BI = { ',' };
                    string[] WI = TEMP.Split(BI);

                    A = WI[0].Trim().ToString();
                    B = WI[1].Trim().ToString().Replace (";"," ");
                    C = WI[2].Trim().ToString();
                    SQL = "INSERT INTO Items(barcode,des,numh) VALUES('" + A + "','" + B + "','" + C + "')";

                        Cmd = new OleDbCommand(SQL, Conn);
                        Cmd.ExecuteNonQuery();
                        Cmd.Dispose();
                    }

what can be the problem ?

thank's in advance