Solved

XL import issue

Posted on 2010-09-02
2
280 Views
Last Modified: 2012-05-10
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#
0
Comment
Question by:SubbuUSA
2 Comments
 
LVL 21

Accepted Solution

by:
MogalManic earned 250 total points
ID: 33595325
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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 33598681
All you have to do is add a column with a data type of uniqueidentifier and give it a default value of NEWID()
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based developeā€¦
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Interā€¦

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question