Ernie,
You'll want to use the "bulk insert" command. Here's the doc from MS.
https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql
Michael Berkowitz
Project Manager, CGS Application Solutions
5530 Corbin Ave Suite 313
Tarzana, CA 91356-6033
Direct: 818 635-0816
Message: 212 261-9610
Fax: 646 710-1889
[log in to unmask]
WWW.CGSINC.COM
D R I V I N G F U N D A M E N T A L S TM
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Newton, Ernie
Sent: Wednesday, October 4, 2017 9:36 AM
To: [log in to unmask]
Subject: [HP3000-L] OT: MS SQL question
Greetings,
I know this is not an SQL listserv, but thought I'd give it a try...
Do any of you know how, using MS SQL, to update a field in a table from a comma-delimited file?
Here's what I'm looking at...
My employee table consists of
employee ID,
name,
address,
phone number,
email address
I have a file consisting of employee ID and email address.
I want to update employee table with email address when employee ID's match.
I know how to do this with Suprtool tables, but I don't have Suprtool for MS SQL. (sad to say)
Thanks in advance,
Ernie
________________________________
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.
* To join/leave the list, search archives, change list settings, *
* etc., please visit https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fraven.utc.edu%2Farchives%2Fhp3000-l.html&data=02%7C01%7Cmberkowitz%40CGSINC.COM%7Cb0154422cc20424ebce008d50b47c4a0%7C0d1ddb6a0fe849d19be97d917d9b18b7%7C0%7C0%7C636427325227284330&sdata=6O%2FQPs2c%2BsQ9aa0jBMG0yOb2Sf5d2%2Fr3jiPPKag4Ffc%3D&reserved=0 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|