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

What Program are you useing
List program and any errors and you will get issues resolved much quicker
Good Luck to You!

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

Are you using VBA or VB6?

I am using vb6 and mssql.

Quote:

---

Originally Posted by dglienna

Are you using VBA or VB6?

---