|
-
Dec 23rd, 2005, 04:16 AM
#1
Thread Starter
New Member
import text file into mssql
the text file format use the length of character to define the field
for example,
0001130130HAUT BAGES AVEROUS 03
9 chars <0001130130> is a field
1 char <H> is a field
20 chars <AUT BAGES AVEROUS 03> is a field
one record by one record store in text
no space, no symbol, no line break between each record
i must use the length of char to define it.
Please help me how to import into mssql
-
Dec 23rd, 2005, 04:32 AM
#2
Addicted Member
Re: import text file into mssql
What Program are you useing
List program and any errors and you will get issues resolved much quicker
Good Luck to You!
-
Dec 23rd, 2005, 10:25 PM
#3
Thread Starter
New Member
Re: import text file into mssql
I want to use package or store prodcedure to import text file into mssql.
it have to run daily and a lot of volumn. Could you give me some suggestions?
thanks a lot
-
Dec 23rd, 2005, 10:32 PM
#4
Re: import text file into mssql
Are you using VBA or VB6?
-
Dec 23rd, 2005, 10:55 PM
#5
Thread Starter
New Member
Re: import text file into mssql
I am using vb6 and mssql.
 Originally Posted by dglienna
Are you using VBA or VB6?
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
|
Reply With Quote
