Text Import

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: HC (heathchester_at_hotmail.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 10:23:59 -0400

Below you will see a section of fixed width data that I need to import into
SQL server. When all the data is on one line, I have no problem, but as you
can see below, each record has multiple parts to it. How can I get the 4
subsequent lines imported in the same record with the demographic data on
line 1?

JONES COUNTY 668NORTHSIDE HIGH 196 1113 4 153 0 20081987413708
372088 0000
11 531 41 81100 78 48140 2120 7
3243341332414242123444314422413222431123322211323312324
531538
11 543 77100 93 85 89 58170 12131716
31431144432414412223332233232143234232114223131121211113333211242
543540
11 505 52100 61 54 500 231413
1221421312114114431341212112324441423332224214341322231212414123232141
01 499 24 60 31 53 50 78 67 420 9 5 8 5 7
8241141342144441212412443243214441234431321141431242444444342411114331112441
43143
JONES COUNTY 668NORTHSIDE HIGH 196 1113 4 222 0 20011987413716
372089 0000
11 518 23 77 90 67 44030 2018 6
1241341332414242123441313421413222434323343131323312224
518522
11 516 33 83 86 55 72 46040 10121113
31432344432414412213332242232143224131114223411133411123131211323
516516
11 511 64 70 78 83 540 161820
1241421312421414431332244112224223421334224241122122223232334423322443
11 518 60 80 69 67 70 89 83 580 121110 7
8102414213244344432433124432433244211341423123114442424244444423111143312431
1142243
JONES COUNTY 668NORTHSIDE HIGH 196 1113 4 253 0 10041987413724
372090 0000
11 560 86100 95 89 53160 2619 8
3243341332414242123441314432413221434123212231323312324
560572
11 552 87 92100 95 89 60170 11141916
31431444432414412223332223232143224232114324121131211133333211242
552549
11 541 95 91 96 92 651 212222
1421421312321414431331232112324423423333224214121122231212431423322433
11 536 88100 88 73100 89 83 681 15141110
8102314313244244442434121432423241411231423123414442224244443424131143312432
2114243
JONES COUNTY 668NORTHSIDE HIGH 196 1133 4 23 09051985
496291 0000
2
0000000000000000000000000000000000000000000000000000000
14 515 30 83 71 70 61 45030 10101411
31334134133414212233332233234143224132114124111131219333323412433
515516
2
0000000000000000000000000000000000000000000000000000000000000000000000
2
0000000000000000000000000000000000000000000000000000000000000000000000000000
0000

Thanks
HC

Relevant Pages

  • Re: Veritas storage foundation HA for windows
    ... This is a solution to manage your data, not the services like SQL Server. ... To make an application cluster suitable ("cluster aware" is for used for ... Most of the time that we have hardware failure, ... Hope you have multiple generators, multiple UPS's, multiple switches, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Role/Person Table?
    ... > reference tables because of multiple values (application owners, users, ... and one of these column would be a constant, the type code. ... generaltypes table. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Multiple SQL*SERVER security holes
    ... I believe they are referring to multiple instances. ... it's own database engine and these instances can ... >"Microsoft offers plug for 'critical' SQL Server holes" ... Does it mean multiple physical software ...
    (microsoft.public.sqlserver.security)
  • Re: Importing CSV into multiple tables
    ... Import the file into a staging table as is. ... Run over the data and import the master rows ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... do multiple tables. ...
    (microsoft.public.sqlserver.dts)
  • Re: Spread table.
    ... > multiple files unless each file is on a separate drive array. ... > Raid 10 and with multiple processors Sql Server can use multiple threads to ...
    (microsoft.public.sqlserver.clients)