Hi guys. I used VB6 and Access 2003 for my backend. Now I want to migrate to SQL Server that will run through ODBC.

My first task is to convert my current Access dbase to SQL.

http://support.microsoft.com/kb/237980

But during the upsize wizard, I am lost. Im stuck with "Select Data Source" and "DSN name"? I am very new to this. Can you give me some helpful link on how to convert Access to MySQL Server and configure the ODBC.

I tried some links but didn't help me much. And one more thing, will the queries with the previous Access be the same? I hope that the only thing I will change are the queries and the connection strings.

I have Vb6 and SQL already installed on the server. Im really confused with the setup.

Guys, please lighten me up with this. Thanks!