update tables from a csv file?

[Sunshine]

Hello and thank you for your time. I have never worked with sql
server and currently have a project updating the database.

I have a CSV file as follows:
id
keywords (this field contains commas within)
date

I have a sql server table as follows with only the id populated.
id
keywords
date

How do I update the sql server fields from the CSV file? I'm assuming
I would use an UPDATE statement. What SQL server utility would I use
(I'm very new at this, please be basic)?

Thank you once again,
Sunshine

[Simon Hayes]

su************@yahoo.com (Sunshine) wrote in message news:<7b**************************@posting.google. com>...

Hello and thank you for your time. I have never worked with sql
server and currently have a project updating the database.

I have a CSV file as follows:
id
keywords (this field contains commas within)
date

I have a sql server table as follows with only the id populated.
id
keywords
date

How do I update the sql server fields from the CSV file? I'm assuming
I would use an UPDATE statement. What SQL server utility would I use
(I'm very new at this, please be basic)?

Thank you once again,
Sunshine

One way is to create a load table with the same structure as the
destination table, and use DTS (Import and Export Data) to load the
CSV file into it. When you've done that, then you can use a query like
this:

update dbo.MyTable
set keywords = l.keyords, date = l.date
from dbo.MyTable t
join dbo.MyTable_Load l
on t.id = l.id

You could also look at bcp.exe or BULK INSERT to load the CSV data.

Simon

[tperovic]

Please post your table structure like this:

CREATE TABLE TableName
(
id int identity not null primary key,
keywords varchar(100),
[date] as datetime -- smalldatetime?
)

and a sample of your data like this:

1
KEYWORD,KEYWORD,KEYWORD,...
05/28/04
2
KEYWORD,KEYWORD,KEYWORD,...
05/28/04

Otherwise, we're forced to make assumptions that may not be correct.

Thanks.
"Sunshine" <su************@yahoo.com> wrote in message
news:7b**************************@posting.google.c om...

Hello and thank you for your time. I have never worked with sql
server and currently have a project updating the database.

I have a CSV file as follows:
id
keywords (this field contains commas within)
date

I have a sql server table as follows with only the id populated.
id
keywords
date

How do I update the sql server fields from the CSV file? I'm assuming
I would use an UPDATE statement. What SQL server utility would I use
(I'm very new at this, please be basic)?

Thank you once again,
Sunshine

[Google User]

Solution 1:
~~~~~~~~~~~
Use DTS and transfer the contents from the CSV file to a table. Join
the original table in the SQL Server and the table created using DTS
and update the table in sql server

Solution 2:
~~~~~~~~~~~
Create linked server in SQL Server for the CSV file. Join and update
the table in sql server.

Hope this helps
Ramesh

su************@yahoo.com (Sunshine) wrote in message news:<7b**************************@posting.google. com>...

Hello and thank you for your time. I have never worked with sql
server and currently have a project updating the database.

I have a CSV file as follows:
id
keywords (this field contains commas within)
date

I have a sql server table as follows with only the id populated.
id
keywords
date

How do I update the sql server fields from the CSV file? I'm assuming
I would use an UPDATE statement. What SQL server utility would I use
(I'm very new at this, please be basic)?

Thank you once again,
Sunshine