Use the wizard that ships with SQL server to do the work. It's fast and, relatively, painless.

With regard to ADO, you could always code directly to ODBC...