Item no is not import in ascending order using data port, i set the property is DataItemTableView SORTING(No.)
The import item no like this
| No. |
|---|
| 4499 |
| 450 |
| 4500 |
| 4501 |
| 4502 |
| 4503 |
| 4504 |
| 4505 |
| 4506 |
| 4507 |
| 4508 |
| 4509 |
| 451 |
| 4510 |
| 4511 |
| 4512 |
| 4513 |
| 4514 |
| 4515 |
| 4517 |
| 4518 |
| 4519 |
| 452 |
| 4520 |
| 4523 |
| 4526 |
| 4527 |
| 4528 |
| 4529 |
| 453 |
| 4530 |
| 4531 |
| 4532 |
How can i import item no is acsending order.
thanks.
The SORTING is only usefull for Exporting records.
If you want to import items in order, you need to write them in the textfile in order.
Another way is to import them and write them into a temptable (=a global recordvariable with property Temptable=Yes) in stead of the real table. After having read all the items, you can loop your temptable in the order you want and process your records.
Is your question more of why do my Items appear in this order? If so then I’m guessing you are on a SQL server version and because you have mixed length items numbers the sorting appears weird! This is because SQL will sort the Items in No. order but with everything LEFT aligned. So they may explain it for you if that was your question, if not i have enjoyed wasting 60 seconds of my life on my favorite website 
Please expalin with some example code for dataport import, item no in ascending order.
thanks in advance.
The items are imported in the same order as they are in the file outside Navision. (As Kriki said)
What You show in Your initial post, looks to me (and apparently also to Littleoaks) like the SQL-way to sort Code-fields.
The order that data are presented inside Navision, has no direct connection to the order it was imported.