Click here to Skip to main content
15,070,974 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to import Data from Text file to Database table.I read the data using File system object.But I can't to import to Database Table.I want the code to Import from File System object to Database.Please help me
Updated 3-Aug-10 18:58pm
Sandeep Mewara 4-Aug-10 1:25am
Show what have you tried and what was the issue. Asking for code directly is not entertained.

You can read line by line, create insert statements and execute this insert statements.
Create an ntext column in a table then insert the contents of the text file into that.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900