export a sorted datagrid

[juve11]

hi,
i want to export to access a sorted datagrid. i managed to sort the datagrid but when i make the export, the mdb file it's without the sort.

[Tequilaman]

It could be an easy solution to use an Excel sheet to save sorted and copy out again. By this the index number can change to the sorted order as well.

You can do the same by saving it to CSV and copying out again (but better not try it with OpenOffice formats, my machine usually stalls if I try to use these directly).

By using CSV you can also exceed 65,556 lines if necessary.

[Killer42]

... i managed to sort the datagrid but when i make the export, the mdb file it's without the sort.

Are you sure? Access returns records in the sequence you request, or (I think) defaults to the sequence of the primary key. The physical order in which the records are stored in a database is usually of little or no importance.

[juve11]

i am making the sort in datagrid,then i insert the rows to access

for i to datagridview1.rowcount
insert into..... values datagridview1.rows(i).cells(0)
next

doesnt work.also i am making a test:

msgbox(datagridview.rows(13).cells(0) -> and this message shows the correct (with sort) row.

[Killer42]

Yes, but what do you mean when you say that Access loses the sort? As I said, when you retrieve the records from the database, Access doesn't necessarily return them in the order you stored them. It depends on things such as:

• The SQL you use,
• The table's primary key, and
• Joins between tables.

[debasisdas]

i am making the sort in datagrid,then i insert the rows to access

for i to datagridview1.rowcount
insert into..... values datagridview1.rows(i).cells(0)
next

When you are inserting records to the database, there is no guarantee that it will store the records in the sequence you have inserted. This is true for all databases. If you want to retrieve from the database you can always sort them logically as per your requirement.