Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

Any ideas on how I can do this?

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
MikeMCSD
Asked:
MikeMCSD
3 Solutions
 
jonnidipCommented:
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
 
tampnicCommented:
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
 
MikeMCSDAuthor Commented:
Excellent suggestions. Thanks all.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now