New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Solved
XL import issue
Posted on 2010-09-02
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#
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#
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
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?
Is that what you want to do?
Do you have a second question on identifying who inserted / updated data?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction:
When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database.
Problems start when you try to combine that with some "user input" pass…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses
Course of the Month11 days, 7 hours left to enroll
718 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.