1 Replies - 1881 Views - Last Post: 22 April 2009 - 02:15 AM Rate Topic: -----

#1 ker19  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 4
  • Joined: 30-December 08

Import flat file to sql server

Posted 22 April 2009 - 12:25 AM

Is there a way to import data from a flat file or a .txt file to a sql server table and implementing the process from vb.net??

Please give a example code for me to start with.

Tnx
Is This A Good Question/Topic? 1
  • +

Replies To: Import flat file to sql server

#2 iwan_tjioe82  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 18
  • Joined: 20-April 09

Re: Import flat file to sql server

Posted 22 April 2009 - 02:15 AM

i just give you some keys...
you need stream reader to read from the file
using split method u can split between field
using the splitted word insert to database using sqlconnection and sqlcommand
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1