vj#: Hi!

I get data from a file, and send them to a table. Is it possible to sort the
data?

Greetings,
Christian.

Hi!

I found it.
It's verry simple.
Only add "... ORDER BY xyz" in the SQL-Statement.
The most times, I think to difficult...

Greeting,
christian.

Correct, and if you want to sort in the reverse order add "desc". Eg.:
"SELECT * FROM Table ORDER BY name DESC"

You can also sort on more than one row by adding the columns like this:
"SELECT * FROM Table ORDER BY LastName, FirstName"

This will give:
Johnson, Bernt
Johnson, Jimmy

If you only do LastName:
"SELECT * FROM Table ORDER BY LastName"
The outout _cound_ give:

Johnson, Jimmy
Johnson, Bernt


Regards,
Lars-Inge Tønnessen

Hi Lars-Inge!

[quoted text, click to view]

Thanks! I forgot this to do in my code, because I need first the
POSTLEITZAHL and then the NAME.

Greetings,
Christian.