[RESOLVED] Access to SQL Server Migration

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!

Whenever I've had to do this I simply migrated the data from Access to SQL Server using a DTS package. I find that much easier to do.

Yeah I found a link using DTS.

http://msdn2.microsoft.com/en-us/lib...3(sql.70).aspx

Is it basically the same as using the Upsizing Wizard of Access? How do I setup the ODBC? Sorry Hack this is my first time to do this. Please bear with me.

You set up ODBC connections using the Data Sources application located in the Control Pannel (Administrative Tools) area.

What should I do first? Setup the ODBC or Migrate my Access to SQL Server?

Im currently running DTS and it says choose a destination. What should I choose?

Microsoft OLE DB Provider? or the ODBC? :(

I got it working guys. Thanks for the help.
I setup the DTS first then setup the ODBC.