I have data in a MS Access table that I want to populate a table in my SQL server. My first thought was to link the SQL table to my Access table, create an Update Query. Sounded easly, but when I go to select the table I want to update to, it's not listed as an option in Append Query setup. Then I loged into my SQL Server Management Studio and thought I would import the data from the Access table into the SQL table. When I choose import and go throught the wizard, I can't see that there is an option to tell it what table to import the data to. Hence it imports the table with the name it had in the Access db. Am I missing something in the wizard? Can I push the data from Access to SQL and tell it what table to go to? Any help would be appreciated! Kelvin
