How do I create a new table to export into SQL from Access using a SQL view?
I am importing data into Access from a SQL view that I created by linking to the view using ODBC. I want to create a new table based on the SQL view and add a couple columns for comments and then export the new table into the SQL database. How do I create the new table with additional comments that links back to the primary key – is this done in Access or do I create the new table in SQL first? After the new table is exported back to SQL, how do I refresh the table so that I don’t lose the comments previously entered? SQL Server 2005 and Access 2007.