Resetting Autonumber during Make Table/Append Table

[Eliphalet]

I'm writing a program to review an imported text file. In
this file, the row number (Which row it was in the file),
is critical to the analysis.

So what I need to have happen is that every time that I
import the data, I need the Autonumber to reset to "1",
and increment up from there.

The only option I see is to Compact after deleting the
previous rows. This seems unwieldy at best.

Any other ideas?

Eli

 

[Tim Ferguson]

In
this file, the row number (Which row it was in the file),
is critical to the analysis.

In that case, the only safe thing to do is to create a routine that adds
the line numbers to the file, or else manage the whole import thing using

Line Input #wFileNum, strInput

and so on.

HTH


Tim F