XL import issue

Hello Experts ,

I am doing a raw import of an XL file in to all nvarchar fields table. It works fine but I want to introduce a GUID column which takes the input from your program and adds it as a first column in the table.

right now I dont have any identity column or differentiation between who uploaded or deleted.

is there a way to do it using c#
SubbuUSAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
MogalManicConnect With a Mentor Commented:
Here is a tutorial on GUID's:http://rhondatipton.net/2007/09/30/generating-a-guid-in-c/

Is that what you want to do?

Do you have a second question on identifying who inserted / updated data?
0
 
Anthony PerkinsConnect With a Mentor Commented:
All you have to do is add a column with a data type of uniqueidentifier and give it a default value of NEWID()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.