|
-
Jul 22nd, 2007, 02:41 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Data From Text File To Database Table
Hello again!
I have a problem. I have an adodc that is connected to a a table in the database. CommandType -> adCmdTabe...... and then i select the table that i want! The problem is that i have a text file which has important data that i want to store to a table in the database. The order inside the txt file is like this:
1st row-> 05/29/2007 14:43:36 242 6.58 0.98 1660 31.3 2.50 2.58 2.64 2.68
2nd row-> 05/29/2007 14:45:40 240 3.03 0.85 668 31.3 1.19 1.22 1.22 1.23
3rd row->....................
740 row ->...................
I have made a table in SQL server with 11 fields. Can anybody post some kind of code so i can read the file(EOF) and save every data into the proper field without using any array in the client(VB 6)? The fields in the database are with the same order as in the file(date time ........)!
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|