Solved

Any ideas on how I can do this?

Posted on 2011-09-21
4
219 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
[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
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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

751 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