asked on

Import Excel data to MS SQL via web interface and validate data

Hi there.

I have an MS SQL database with a classic asp interface spiced up with Javascript, jquery, VB etc.. I have to create a procedure like this:
User download an Excel spreadsheet, enter some data in predefined columns and upload it to my server via a web interface. Here the data must be imported to a MS SQL database and in the same process be validated against some validation rules like:
only numbers to number fields, values in a certain range etc..
I know it's possible. It doesn't have to be classic asp. It can also be aspx. I'm just not so familiar with aspx yet. My server is a pure Microsoft server with web and database. Anyone who has got a useful guide or can assist with the vital codes to perform this procedure? I have all on a dedicated server.
I look forward to some input. :-)

Best regards

Ulrich

ASKER CERTIFIED SOLUTION

HainKurt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Alexander Ardatov

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Big Monty

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ullenulle

ASKER

Hi guys.

I'm working on stuff. I'll be back in a few days.

Best

Ulrich

ullenulle

ASKER

Thanks for the input. I jumped into using Visual Studio and asp.NET. I will have lots of questions in the near future and will try to narrow them down to one a time. :-) Please take a look at my new question.

Best regards

Ulrich