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
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!
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
Re: import text file into mssql
Are you using VBA or VB6?
Re: import text file into mssql
I am using vb6 and mssql.
Quote:
Originally Posted by dglienna
Are you using VBA or VB6?