This is more of a general question. I want to port an Access DB over to SQL server. Has anyone every done this before and if so could you recommend some upsizing tools and enlighten me about any problems that you might have encountered. Im aware that all the DAO code will have to be changed to reflect ADO(fun fun).

Thanks

Scott