473,473 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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

3 New Member
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
5 3869
ck9663
2,878 Recognized Expert Specialist
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
kartthii
3 New Member
sir im a beginner.. i cant understand.. could u plz tell me in details
Jan 24 '08 #3
ck9663
2,878 Recognized Expert Specialist
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
kartthii
3 New Member
there is no import option.. what can i do
Jan 25 '08 #5
ck9663
2,878 Recognized Expert Specialist
there is no import option.. what can i do

ask your admin to give you BULK INSERT rights..

-- ck
Jan 25 '08 #6

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

Similar topics

2
by: jet | last post by:
Hi, Maybe this is an easy task, but I'm having a really hard time figuring out how to do this. I'm a complete newbie to SQL Server. I have a database dump file from MySQL that's in .sql...
0
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer...
3
by: Davy B | last post by:
I am trying to import a data file, which is tab delimited, using BULK INSERT. I have used BCP to create a format file, since the destination table has around 20 columns, but the data file has only...
1
by: Chicagoboy27 | last post by:
Is there a way to import multiple csv files from a directory into sql 2005? The situation I have right now is that I have a folder with multiple csv files that i need to import into sql 2005. I can...
6
by: EricR | last post by:
I am trying to bcp import a text file into a SQL Server 2000 database. The text file is coming out of a java application where order information is written to the text file. Each record is on it's...
4
by: M6C | last post by:
Hello, I'm trying to import a Xml file in a table. It's working find, but when the data are inserted, my trigger on this table doesn't work ? I put my code below. Best regards Thank's
8
by: =?Utf-8?B?Ym9iYnk=?= | last post by:
Could you please help me in this project. I have aTab delemeted file. It has 20 columns and some data. I have to import this data into SQL Server. I am using sql express edition. I am using...
0
by: mleger | last post by:
Ive been working on this script that does 2 things. 1 it creates a table, and the 2nd part imports a csv file into that table. BULK INSERT PHCR_YEARM+D! FROM...
14
by: Raman Pahwa | last post by:
I have a notepad with different fields.I want to import it in sql 2005. In Sql 2005,there are rows and columns. Just want to know which option should select for rows and column delimiters.
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.