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

how to import values from a notepad file to a sql server 2005 table

P: 3
i have a notepad file with comma seperated values, i want those values to be imported in a table created in sql server 2005.. plz anyone help
Jan 24 '08 #1
Share this Question
Share on Google+
5 Replies


ck9663
Expert 2.5K+
P: 2,878
i have a notepad file with comma seperated values, i want those values to be imported in a table created in sql server 2005.. plz anyone help
use your sql management tool and import the file as a flat delimited file...

-- ck
Jan 24 '08 #2

P: 3
sir im a beginner.. i cant understand.. could u plz tell me in details
Jan 24 '08 #3

ck9663
Expert 2.5K+
P: 2,878
sir im a beginner.. i cant understand.. could u plz tell me in details
open your sql server manager...in sql2005 it's called sql management studio. go to the database where you want to upload the file. right click the database. choose import..follow the wizard...


-- ck
Jan 24 '08 #4

P: 3
there is no import option.. what can i do
Jan 25 '08 #5

ck9663
Expert 2.5K+
P: 2,878
there is no import option.. what can i do

ask your admin to give you BULK INSERT rights..

-- ck
Jan 25 '08 #6

Post your reply

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