Import csv file into existing table

[SuperComputing]

OK I have a table with data like so:

COL1     |COL2|COL3| COL4 | COL5
------------------------------------
12340001 | 01 | 24 | XXXX | ________
12340002 | 08 | 03 | XXXX | ________
12340003 | 12 | 22 | XXXX | ________

And I have a csv like so:

1234001,ABCD
1234002,EFGH
1234001,IJKL

I need to (Bulk Insert?, maybe) the csv into the existing table. Read a line from the csv, compare the number in column 1 of the csv with the number in column 1 of the table, and when it finds a match, places the data in column 2 of the csv into the blank column 5 of the table. Next line...

Any suggestions or help GREATLY appreciated!!!

 

[bborissov]

Insert that data in TEMP table and then use INNER JOIN between existing table and inserted records to get what you want.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[JackVam]

Step 1
Create temp table

CREATE TABLE #tempTable
(
columns
)
Step 2
BULK INSERT OrdersBulk
FROM 'c:\myfile.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Step3
Comparison

Step4
DROP TABLE #tempTable

All the IT jobs in one place -

http://www.ITjobfeed.com