Hi Bhupinder,
I'm surprised that it's random -- if the destination table has a
primary key, it should be sorting the records according to that key.
Still, if you use VBA to transfer the data, as another poster
suggested, you can add your own row index.
A nice strategy I discovered recently that will speed things up
immensely: Instead of manipulating cells individually, you can get a
two-dimensional array of type Variant that contains the values of
each cell in a range. In other words,
Dim varValues() As Variant
varValues = Range("A1:D9").Value
Good luck,
Peter Hoogenboom
--- In [email protected], "Bhupinder" <[EMAIL PROTECTED]>
wrote:
>
> hi ,
>
> i am working with MS Access 2000 and Excel. I need to keep track of
row
> number of the record that i have imported from excel using
> "DoCmd.TransferSpreadsheet"
>
> As it does not import the rows as it is in the excel sheet.
> it imports all the records randomly.
>
> Apart from this could you pls tell me how can i add a autonumber
column
> to an existing table programiticaly or by a query so that i can
call it
> in my program.
>
> Please Help me.
>
> Thanx in advance.
> Bhupinder Singh
>
