hello, I have a VB , Access application(used ADO objects) which I want to migrate MS Access to SQL Server. I want to know whether the Upsize...

hello, I have a VB , Access application(used ADO objects) which I want to migrate MS Access to SQL Server. I want to know whether the Upsize wizard available with Access or DTS Import/Export wizard available with SQL Server is a good tool for doing that. Also, please help me in giving me the steps required in doing that and also things to take care of . I dont have any queries written in Access database. All the queries were called from VB application. Do I need to convert them into stored procedures or views ? Also the data types I am dealing with are text, autonumber, number, memo, yes/no, currency. I dont have any forms or reports also from Access. The frontend is entirely VB. what are the things to take of in that case ? please help me in this regard. mahesh