INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'SELECT id,col1 FROM [Sheet1$]')
SELECT id,col1 FROM temp_test order by id
Everything works fine....
but the order by clause is not recoginsed
when i use the query in analyser it works correctly with order by clause,
but while xporting it is not working.