Resetting Autonumber during Make Table/Append Table

  • Thread starter Thread starter Eliphalet
  • Start date Start date
E

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
 
In
this file, the row number (Which row it was in the file),
is critical to the analysis.
Click to expand...

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
 
Back
Top