Excel Transfer- Sorting (1 Viewer)

[paulcherianc]

Am trying to transfer a table to excel with the following code. But i am not getting the data in ascending order with a specific column. Can anyone help me plz.:banghead:

Set rs = db.OpenRecordset("QUG_Accident_Register_MainTable", dbOpenSnapshot)

 

[paulcherianc]

I think i have found a workaround!

Set rs = db.OpenRecordset("SELECT QUG_Accident_Register_MainTable.* FROM QUG_Accident_Register_MainTable ORDER BY QUG_Accident_Register_MainTable.Date ASC;")

 

[CJ_London]

that is the usual solution. In pretty much any situation you never access tables directly, only through queries