Convert MSaccess db to sql2005 db.....pls help!!!

[spider1916]

pls help!!!

i need to write (or if someone knows of existing code) a vb6 application that will convert an ms access db to a sql2005 db. i have done some research and have found variase applications enabaling one to do exactly this. but none to my liking/needs. i am realy stuck on this one......pls help!!!

thanks
spider1916

[CaptainD]

pls help!!!

i need to write (or if someone knows of existing code) a vb6 application that will convert an ms access db to a sql2005 db. i have done some research and have found variase applications enabaling one to do exactly this. but none to my liking/needs. i am realy stuck on this one......pls help!!!

thanks
spider1916

Why not use Enterprise Manger (Or what ever SQL 2005 now calls it) and run the upsize wizard?