Actually I'm trying to use the Upsizing Wizard in Access instead of the ODBC tool (the latter of which I can get to through the control panel or Access itself has a tool built in)... I already have the tables in Access and just need to recreate them (and thus move their contents and structure) to SQL Server. The beauty of the Upsizing Wizard is touted that it simply moves the table from Access to SQL Server and all functionality remains - one can write to the SQL tables and read from them.

Seems that if all I needed was to use the ODBC tool it would assume that there is data in the SQL Server table to start with, which is not the case. All my data is in Access.