How to use order by clause in insert into statement
-
Hi Friends, I have one problem i m creating MDB(access databse) file from text file.i get field name and field value sequentially.But when mdb file is generated,it's sequence is different.So how to solve this problem.I want MDB file data sequential. Reply me. Thanks in advance..
-
Hi Friends, I have one problem i m creating MDB(access databse) file from text file.i get field name and field value sequentially.But when mdb file is generated,it's sequence is different.So how to solve this problem.I want MDB file data sequential. Reply me. Thanks in advance..
The SQL statement would be
SELECT * FROM WHERE ORDER BY
Not sure if there is any change for access database.
«_Superman_» I love work. It gives me something to do between weekends.
-
Hi Friends, I have one problem i m creating MDB(access databse) file from text file.i get field name and field value sequentially.But when mdb file is generated,it's sequence is different.So how to solve this problem.I want MDB file data sequential. Reply me. Thanks in advance..
jadhavjitendrar wrote:
How to use order by clause in insert into statement
AFAIK you cannot do than. However, you may add a counter field to the table and then use it to order data when querying. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]