Solved

Any ideas on how I can do this?

Posted on 2011-09-21
4
210 Views
Last Modified: 2012-05-12
I have this process that I'm going to have to do weekly :

I have a "SKU" field (will be used for the ID field) and a "Inventory" field from an Excel .xls sheet I download weekly.
I need to use those 2 fields to update some fields in a Table in a SQL Server database.

I could use C# code and/or SQL.

What would be the easiest way to do this?

0
Comment
Question by:MikeMCSD
4 Comments
 
LVL 6

Accepted Solution

by:
bartvd earned 167 total points
ID: 36575954
0
 
LVL 13

Assisted Solution

by:jonnidip
jonnidip earned 167 total points
ID: 36578373
I suggest you to use Excel DataReader (http://exceldatareader.codeplex.com/), to read from your files.
It is a very good implemented library and lets you work with xls (in reading) without using interop.

Regards.
0
 
LVL 7

Assisted Solution

by:tampnic
tampnic earned 166 total points
ID: 36579468
One option is to create an Access database - use ODBC to create table connections to the main database and the Excel file. Create an Access Query to read the Excel table and INSERT/UPDATE/whatever the database table - you can run functions on the data and validate it before sending to your database if you want. Simple to setup and very flexible - though not as automated as writing something in code. The code route could get tricky depending on your experience, if you're comfortable with SQL this option would look attractive.

Cheers,
  Chris
0
 
LVL 16

Author Comment

by:MikeMCSD
ID: 36584596
Excellent suggestions. Thanks all.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now