I use Access a lot (with SQL Server as the backend). It seems to me the simplest way is to create the table in SQL and link to it in Access..then use an Access Append query to "move" the data to the SQL table...