SQL help
For all the SQL users in this forum:
I have a SQL server and i was wondering about an app i made in vb6. I have all the drivers installed and i'm using the generic data control in vb6. it opens the database (anime.xls) fine but the order is screwed up. I have 48 entries in my database and it shows 1-16 perfectly but then goes to entry 38-48 and then back to 17-37. I have tried to use sql command but none will fix it. here is the code used to open the database:
ODBC;DSN=Excel Files;DBQ=C:\anime.xls;DefaultDir=C:\WINDOWS\syste m32;DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;UID=admin;
any help is greatly appreciated.
__________________
************* RavenChild **************
|