Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Question Unanswered: vb.net with access

    Hi,

    I have coded a program in VB.net which takes in numbers from a file and makes it as a table in MSaccess.
    But i am getting an error :

    num = file.ReadLine()

    I stored the number in num which is a string.

    This is my insert statement.
    sql = "insert into meera2(id) values(num)"

    id is decimal type.Now if i have to write the value of num in id in the above insert statement,it is not getting written down in table.it says not enough paramters,ie it is not taking the values.
    how do i do it.
    thanks
    meera

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: vb.net with access

    Try this

    "INSERT INTO MEERA2(id) SELECT num"

    Also I highly recommend this control:

    http://www.geocities.com/scirocco_ha/DataControl.htm

    Originally posted by meerasan
    Hi,

    I have coded a program in VB.net which takes in numbers from a file and makes it as a table in MSaccess.
    But i am getting an error :

    num = file.ReadLine()

    I stored the number in num which is a string.

    This is my insert statement.
    sql = "insert into meera2(id) values(num)"

    id is decimal type.Now if i have to write the value of num in id in the above insert statement,it is not getting written down in table.it says not enough paramters,ie it is not taking the values.
    how do i do it.
    thanks
    meera

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •