S
seaweed
I am importing data that is in a plain text file, delimited by tabs.
There is an autonumber field. After hours of fiddling I have
finally discovered that I must prepend each line/record in the input
file with a tab, presumably to delimit the autonumbered field from
the first datum that will go into the next field.
When I initially load in from a file, the autonumb field gets values:
1,2,3...
Data loaded in from a second file start with 55124193, 55124194....
Of course, since it is only a key it doesn't matter what value the
identifier gets as long as I don't run out of integers, but is there a
way to force the numbering to start at the next consecutive integer?
There is an autonumber field. After hours of fiddling I have
finally discovered that I must prepend each line/record in the input
file with a tab, presumably to delimit the autonumbered field from
the first datum that will go into the next field.
When I initially load in from a file, the autonumb field gets values:
1,2,3...
Data loaded in from a second file start with 55124193, 55124194....
Of course, since it is only a key it doesn't matter what value the
identifier gets as long as I don't run out of integers, but is there a
way to force the numbering to start at the next consecutive integer?