transfer data from excell to vb or sql

Discussion in 'Programming' started by jojehcomputer, Aug 2, 2006.

  1. #1
    Hello ,
    I have an application in vb that must gets excell applicatiom and transfer data from excell worksheet to table of sql? how can i do this work? tanks for reply.
    :confused:
     
    jojehcomputer, Aug 2, 2006 IP
  2. talentcoder

    talentcoder Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    export the data in cvs format and then import (LOAD DATA) into a sql database., or post a project at talentcoder.com get someone handle it for you.
     
    talentcoder, Aug 3, 2006 IP
  3. rahulm

    rahulm Peon

    Messages:
    178
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Or u can generate a XML file of that data by coding and than by a loop u can enter the whole data in sql table
     
    rahulm, Aug 7, 2006 IP
  4. Edynas

    Edynas Peon

    Messages:
    796
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    0
    #4
    if you want to transfer data from excel to sql take a look at www.navicat.com
     
    Edynas, Aug 8, 2006 IP
  5. Froggie

    Froggie Well-Known Member

    Messages:
    665
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #5
    or you can give me more details and i will do it for a reasonable price
     
    Froggie, Aug 10, 2006 IP