Assigning imported data to tables / categories

[Andy Roberts]

I'm importing data as follows:-

0001,652.8655,349.5133,689.3182,468.6107
0002,822.5105,468.6107,861.7672,336.9030
0003,1020.1960,336.9030,1051.0406,505.0405
0004,1154.7904,505.0405,1330.0435,356.5190
0005,1531.9351,440.5878,1426.7832,573.6967
0006,1505.2966,743.2354,1799.7218,419.5706
0007,1913.2858,619.9345,1530.5330,928.1867
0008,1913.2858,619.9345,1530.5330,928.1867

They are start and end points of section lines along a river. I'm importing
different files each day, but always in the same format. Each of these
records belongs to a river, so what I need to do is then assign a category
to each record, but I would like to block select say 10 records and assign
them to one category, rather than do each one individually.

What is the best way to go about this?

Andy

 

[Joseph Meehan]

I'm importing data as follows:-

0001,652.8655,349.5133,689.3182,468.6107
0002,822.5105,468.6107,861.7672,336.9030
0003,1020.1960,336.9030,1051.0406,505.0405
0004,1154.7904,505.0405,1330.0435,356.5190
0005,1531.9351,440.5878,1426.7832,573.6967
0006,1505.2966,743.2354,1799.7218,419.5706
0007,1913.2858,619.9345,1530.5330,928.1867
0008,1913.2858,619.9345,1530.5330,928.1867

They are start and end points of section lines along a river. I'm
importing different files each day, but always in the same format. Each of
these records belongs to a river, so what I need to do is
then assign a category to each record, but I would like to block
select say 10 records and assign them to one category, rather than do
each one individually.
What is the best way to go about this?

Andy

How many records a day? How many different "blocks" are you expecting
per day?

Will you always be doing this or will different people do it? (How
automatic and bullet proof does it need be?)

 

[Andy Roberts]

Joseph

I envisage about 10-20 records a block and about 5 blocks a day imported by
a couple of different people. I'm not too worried about how bullet proof it
is as long as I can explain to them the procedure
Andy

 

[Joseph Meehan]

I'm importing data as follows:-

0001,652.8655,349.5133,689.3182,468.6107
0002,822.5105,468.6107,861.7672,336.9030
0003,1020.1960,336.9030,1051.0406,505.0405
0004,1154.7904,505.0405,1330.0435,356.5190
0005,1531.9351,440.5878,1426.7832,573.6967
0006,1505.2966,743.2354,1799.7218,419.5706
0007,1913.2858,619.9345,1530.5330,928.1867
0008,1913.2858,619.9345,1530.5330,928.1867

They are start and end points of section lines along a river. I'm
importing different files each day, but always in the same format. Each of
these records belongs to a river, so what I need to do is
then assign a category to each record, but I would like to block
select say 10 records and assign them to one category, rather than do
each one individually.
What is the best way to go about this?

Andy

How is the data coming in? Is it written or electronic? If electronic
what is the format?