Advertisement

05.07.2008 at 01:27AM PDT, ID: 23381975
[x]
Attachment Details

Update a SQL server table using a csv file

Asked by optimumreports in SQL Server 2005

Tags: SQL Server

Can anyone help?

Our SQL server 2005 database has a dbo.tblpupil table with various fields within it; i.e. PupilUserID, int - PupilSurname, varchar(128) - PupilClass, varchar(50)

What i need to be able to do is update this table from a csv file.Start Free Trial
 
Keywords: Update a SQL server table using a csv…
Title
1 CSV Coldfusion and MySQL
2 CSV into XML
3 Export SQL table with column name to …
4 export to csv from sql on the fly
5 Import CSV file
6 php mysql db query and csv output
 
Loading Advertisement...
 
[+][-]05.07.2008 at 01:31AM PDT, ID: 21514197

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 01:31AM PDT, ID: 21514199

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: SQL Server
Sign Up Now!
Solution Provided By: VMontalvao
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628