how to import data?

hello ....

I'm doing my assignment and facing some problem.

The problem is I don't know how to read data from text file or excel file and store it into database.

Can anyone help please.........



Answer this question

how to import data?

  • TFolsom

    hi, angelLee

    to read from file that depend on the file type hat you want to use , so you have to determine which file type that you want to use as datastorage to find proper way to connect to it and to retireve data from it, and how data is formated in this file

    hope this helps



  • NightFlight

    Thanks for ur reply Kal...

    but my situation is ...my system have a system call import..which allow user to import a file (content of the file might be e.g student ID and student name)...

    so how can I read it from file and store the student ID and student name into my database for the student ID field and student name field


  • Jeff Osborn

    Reading Data from a text file

    suppose ur text file in this location:c:\\hello.txt;

    streamreader s=new streamreader(@"C:\\hello.txt");

    textbox1.text=s.ReadToEnd();



  • how to import data?