Guys,
I have an Unformatted Text file that I need to import into SQL Server2000. Can you guys help me how to import this data into a Temp Table in sql server 2000. Each field is separated by a Semi Colon in a row. I am using VB.NET . Here is the sample file.
For Example:
If we take a first row that is “21” then in that ‘CJDS ADVERTISING-DENVER’ needs to go to “ADVERTISER” in TempTable and “PO BOX 1999” needs to go to ‘ADDRESS’ in Temp Table and so on. Appreciate your help.
Thanks,
21;1;CJDS ADVERTISING-DENVER ;PO BOX 1999;42ND FLOOR;1999 BROADWAY,DENVER, CO 80202;;CO; …
22;KJDS;TV;N;KJDS-TV - LAKEWOOD, CO;COLUMBINE/JDS SYSTEMS;1999 BROADWAY, SUITE 4000;DENVER, CO 80202-3050;;JDS; …
23;KJDS-TV - LAKEWOOD, CO;COLUMBINE/JDS SYSTEMS;1999 BROADWAY, SUITE 4000;DENVER, CO 80202-3050;; …
24;THIS IS A BIAS INVOICE THAT PRINTS ON TOP THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP / LINE 2; …
24;THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP / LINE 2; …
25;WE WARRANT THAT THE BROADCAST; …
25;INFORMATION SHOWN ON THIS INVOICE IS; …
25;WITHIN TWO MINUTES OF THE ACTUAL TIME.; …
31;CJDS-ATLANTA;TEST SALESPERSON;INVOICE TEST;EI TEST PRODUCT;990228;1;;82474;9902;990201;990228;980201;990228;;;;;;;;0;2081;448;;EIPRO; ;;;;;;;; …
32;THIS IS AN ORDER/INVOICE COMMENT; …
41;1;MTWTFSS;1000;1030;;10000;;;;;; …
51;Y;990204;4;1005;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990213;6;1028;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990215;1;1015;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990224;3;1025;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
41;3;MTWTFSS;1000;1030;;10000;;;;;; …
51;Y;990205;5;1005;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990216;2;1025;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
41;6;MTWTFSS;1000;1030;;10000;;;;;; …
51;N;990207;7;0000;30;;10000;;;;;;;;;10000;;N;;;;; …
52;DID NOT AIR; …
51;N;990208;1;0000;30;;10000;;;;;;;;;10000;;N;;;;; …
52;DID NOT AIR; …
51;N;990219;5;0000;30;;10000;;;;;;;;;
I have an Unformatted Text file that I need to import into SQL Server2000. Can you guys help me how to import this data into a Temp Table in sql server 2000. Each field is separated by a Semi Colon in a row. I am using VB.NET . Here is the sample file.
For Example:
If we take a first row that is “21” then in that ‘CJDS ADVERTISING-DENVER’ needs to go to “ADVERTISER” in TempTable and “PO BOX 1999” needs to go to ‘ADDRESS’ in Temp Table and so on. Appreciate your help.
Thanks,
21;1;CJDS ADVERTISING-DENVER ;PO BOX 1999;42ND FLOOR;1999 BROADWAY,DENVER, CO 80202;;CO; …
22;KJDS;TV;N;KJDS-TV - LAKEWOOD, CO;COLUMBINE/JDS SYSTEMS;1999 BROADWAY, SUITE 4000;DENVER, CO 80202-3050;;JDS; …
23;KJDS-TV - LAKEWOOD, CO;COLUMBINE/JDS SYSTEMS;1999 BROADWAY, SUITE 4000;DENVER, CO 80202-3050;; …
24;THIS IS A BIAS INVOICE THAT PRINTS ON TOP THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP / LINE 2; …
24;THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP THIS IS A BIAS INVOICE COMMENT THAT PRINTS ON TOP / LINE 2; …
25;WE WARRANT THAT THE BROADCAST; …
25;INFORMATION SHOWN ON THIS INVOICE IS; …
25;WITHIN TWO MINUTES OF THE ACTUAL TIME.; …
31;CJDS-ATLANTA;TEST SALESPERSON;INVOICE TEST;EI TEST PRODUCT;990228;1;;82474;9902;990201;990228;980201;990228;;;;;;;;0;2081;448;;EIPRO; ;;;;;;;; …
32;THIS IS AN ORDER/INVOICE COMMENT; …
41;1;MTWTFSS;1000;1030;;10000;;;;;; …
51;Y;990204;4;1005;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990213;6;1028;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990215;1;1015;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990224;3;1025;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
41;3;MTWTFSS;1000;1030;;10000;;;;;; …
51;Y;990205;5;1005;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
51;Y;990216;2;1025;30;EI TEST INVOICE;10000;;;;;;;;;;;N;;;;; …
41;6;MTWTFSS;1000;1030;;10000;;;;;; …
51;N;990207;7;0000;30;;10000;;;;;;;;;10000;;N;;;;; …
52;DID NOT AIR; …
51;N;990208;1;0000;30;;10000;;;;;;;;;10000;;N;;;;; …
52;DID NOT AIR; …
51;N;990219;5;0000;30;;10000;;;;;;;;;
