Sorting a table with out a primary or index key

[Gobroski]

I have created an Access Database using OLE automation. In that database, I have created some tables with this line of code:

Query->SQL->Text = "CREATE TABLE Student_Information([SID] Int,[Last] VarChar(15),[First] VarChar(15))";
Query->ExecSQL();

I know I am missing my Index declarations, but I don’t want any. The data I am entering could and probably will have duplicates. I need to sort this Table ascending by last name then first name.

Any ideas?

Thanks,

Lee

 

[Wings]

Just use an SQL query to sort it

Query->SQL->Text = "SELECT Companyname, Contactname FROM
Customers ORDER BY CompanyName";