By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

import data from excel to sql database

P: 8
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..
May 5 '10 #1
Share this Question
Share on Google+
3 Replies


MrMancunian
Expert 100+
P: 569
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
May 6 '10 #2

P: 8
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..
May 12 '10 #3

Curtis Rutland
Expert 2.5K+
P: 3,256
http://support.microsoft.com/kb/316934

This should help you do what you want.
May 12 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.