migrating access to SQL

i am doing ASP small project using ACCESS database
i want to migrate access to SQL what i need to do?
it is very diificult. i studied sql very well.but i don't know what s/w i need to download how to make connection????

Quote:

Originally Posted by subashini Thiyagarajan

i am doing ASP small project using ACCESS database
i want to migrate access to SQL what i need to do?
it is very diificult. i studied sql very well.but i don't know what s/w i need to download how to make connection????

Hi there,

Make use of the Import and Export wizard, hope it helps. Good luck & Take care.|||How can i do that?

what changes i should make in my asp codings?

in order to export to SQL what s/w i need to download?

pls reply|||

Quote:

Originally Posted by subashini Thiyagarajan

How can i do that?

what changes i should make in my asp codings?

in order to export to SQL what s/w i need to download?

pls reply

Hi there,

Not much changes are required as long as you provide the source & destination database name correctly, that's more then enough i guess. Good luck & Take care.|||Here is a MS article about doing this although not sure what version of SQL Server you are using.

HTH,
Aric|||thanks for your reply.
can i get SQL server free download from Net.Not a trial version.|||

Quote:

Originally Posted by subashini Thiyagarajan

thanks for your reply.
can i get SQL server free download from Net.Not a trial version.

Hi there,

The answer will be NO & NOTHING BUT NO! Good luck & Take care|||It is confirmed "NO"

what did u mean that source and desrtination path should be correct.

using which source i should concentrate about the path.
i downloaded the express edition what i need to do in order to import my access file? pls give a clear viewsql