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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
All Courses

From novice to tech pro — start learning today.