Import code sometimes changes rows

[RamziSaab]

I have a code using docmd.transferspreadsheet...

now this work fine most of the time, but sometimes it will mix the rows around i.e. row 10 will be row 1 etc. does anyone know why or has seen similar behaviour?

 

[MichaelRed]

'TransferSpreadsheet' is essientially an import process. If you transfer to an existing recordset (table) and that table includes an index, viewing the results would normally occur throung hte index. It does not (necessarily) mean that the data itself has been re-ordered, only the 'view'. To see if this is occuring, check for indicies in the table (particularly after 'observing' the altered sequence).

It is possible that some user is 're-arranging the table through the 'sort' buttons on the menu bar -and saving the table without realizing that the change is thus 'permanant'.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places