Insert data using Excel Spreadsheet

[chrisppppp]

SQL Server 2005

Sorry i'm a bit of a novice when it comes to SQL but i can just about get by. what i need to do however is Insert data from an excel spreadsheet into a table that already exists in my database, basically just to add to the list i already have there.

Basically it is a table with two columns:

GF1_Policy_ID (Float)
GF1_U/W_1 (nvarchar 22)

i've looked at the import feature on the import wizard but everytime it wants to create a new table rather than insert the data into an already existing table.

Any help or suggestions please?

 

[drlex]

Chris,
With the import wizard, choosing "Copy data from one or more tables or views" should give you a window where the Wizard offers you a table named after the first sheet in your spreadsheet. If you click on this suggested table
(in the form [<destination db name>].[dbo].[<sheetname>]), you should see a down arrow to the right, which when clicked on, will provide a drop down list of all existing tables.
Select the correct one, and then click on the 'Edit...' button under the Mapping heading to confirm/amend the mappings which SQL server has created.

soi la, soi carré

 

[chrisppppp]

Seems so simple if you look at it properly, thanks for your help i've managed to be able to do what i needed.