asked on

MS SQL 2000 importing from csv file to update records

Hi SQL Gurus,

I'm sql neewb here and I'm trying to achive the following:

I have a table for user records and there's a specific column for email addresses that is not 100% updated yet...I created a query that displays: "FirstName", "LastName", and "Email" column data only.

I want to then save the results to a CSV file, distribute to a person to use a data entry form as he/she updates all the email addresses and then import the file back to the database and update where necessary.

What's the best way to achive this? I repeat, I need step by step instructions since I'm neewb...thanks!

ASKER CERTIFIED SOLUTION

kenwagers

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jetli87

ASKER

thanks for the response.

Here's what i got with the my query below...The XLS is attached.

I'm a bit confused on applying the formula...Can you added and send back?

Much appreciated.

select hmyperson as Primarykey, Sfirstname as Firstname, slastname as Lastname, saddr1 as Address, sunitcode as Unit#, semail as 'Email Address' from tenant where hproperty =4 and istatus =0
order by sunitcode

Open in new window

Sample.xls

kenwagers

Glad to. That's often the hard part.
sample.xls

jetli87

ASKER

lol...omg, that makes so much sense...thanks!

kenwagers

I saw your table / field names after I posted it - this one has the right names and should be close to what you need.
sample.xls

jetli87

ASKER

no worries, after looking at the first one, i understood the concept...thanks again.