This is a problem that a have been racking my brain with ALL week and I cannot come up with anything. Here we go:
I have an Access db. I need it to be in order by specific columns, A and B. When I import the data (from a captured text file) there is no way for me to pre-sort the data to enter it the way I need it. After I import the data, how can I sort it so that it is in order by columns A and B? I would use SQL "ORDER BY A, B" but the db is too large to do that each time. I've tried indexes but ADO does not support indexes on Jet dbs. I've tried recordset.Sort, which would be fast enough to do each time, but again ADO does not support recordset.Sort on Jet dbs. The best solution I have come up with is to use an SQL Statement similer to:
"SELECT * INTO table1 FROM table ORDER BY A, B" however, I cannot find how to rename the table from 'table1' to 'table' after I 'DROP' table. Also, that approach is not good because of the size of the db. I can't copy and delete tables like this. Is there any way that I can use ADO, and Jet to sort this db short of adding an indexed column 'AB' which is (A & B)?
PLEASE HELP ME!!! Thanks
