Link to home
Start Free TrialLog in
Avatar of rito1
rito1

asked on

Importing excel data into SQL Server 2008 via ASP.NET

Hi All,

What would be an effective solution to enable a client to import excel data into SQL Server via an ASP.NET interface.

The interface will expect the excel data to be in a particular column format and will need to validate that all data is available within the excel file being imported.

I did develop a solution about 1.5 years ago which utilised the SQLBULKCOPY class... Is this still a sound solution or are there better methods to use?

Thanks,

Rit
ASKER CERTIFIED SOLUTION
Avatar of Rouchie
Rouchie
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rito1
rito1

ASKER

Excellent thanks Rouchie. I'll start my research on SQL Server 2008 data types. This sounds pretty cool!