import data from excel to sql database

[harmony123]

hi have anyone tried importing specific column of an excel sheet to an sql database?
i have tried importing data from excel and it worked but my problem is i want to import only specific columns from my excel file not necesarily importing all the columns..

[MrMancunian]

What did you try yourself? If you know how to import data from Excel, it shouldn't be too much trouble to get some specific columns... Let us know what you need!

Steven

[harmony123]

i have a database table named tblAbra which has columns: id,project,january,february,march,april,may-december..now im going to populate these table by importing the data from excel..since the population of the data are on monthly basis..those columns who don't hve data yet are set to null..example if im going to add the 1st data im going to import it from excel importing only the data from january column..now if the data of february is already available im going to import that again adding it to my database column february not necesarily importing the data from january column since im already imported it earlier..
my problem now is how am i going to add those data i've imported from excel from february column to my database february column..cause when i've used insert command it is being added to the last row of my database not to the 1st row..

[Curtis Rutland]

http://support.microsoft.com/kb/316934

This should help you do what you want.