Sequence in table without primery key 1

[Niebotel]

I'm creating a txt file as an interface to another program.
The first step is that I add records to a table; after that I export it as an TXT file.

If I look to that table the sequence is not the sequnce in which I addded the records.

I can solve it quit easy by adding a autonumbering field but my interface does not want to have such a field. How can I force the sequence of the records in my table equal to the sequnce I added the records?

I'm using:
rstIn.Open "[InterfaceFacturen]", con, adOpenStatic, adLockPessimistic

rstIn.AddNew
and rst.update

 

[PHV]

Use an AutoNumber field ant hen export a query sorted by this number.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

Again great; and so simple!
Thanks