Importing Excel data into SQL 2005

[MarkWest05]

Hi,

I am trying to import data from excel into an existing database, however, it will not allow me the option to inport into a existing table, only into a new table. Can anyone help me?

 

[csmeutah]

in the select source tables and views window, select the worksheet and in the destination column if you click on the table name it defaults to it will give you a drop down button which will list all the tables. Edit mappings at the bottom will let you map them.