export data from excel file and import to sql server

[Clive Hoggar]

Hi

I am using RadUpload to upload an excel spreadsheet file to a web server.
I then want to map the columns to a database table and import the content to a database,
in code behind. (preferably VB)

I feel there must be some existing code or a third party component to do that, but I have
not been able to find anything.  Can anyone give me some pointers?

OK I can write the code, but this must exist somewhere already.

Thanks

Clive

[Bhanu]

Hi,

Facing the same prob. Can anyone give a solution?

[Helen]

Hi,

Probably you will find helpful:
http://davidhayden.com/blog/dave/archive/2006/01/13/2692.aspx

Kind regards,
Helen
the Telerik team

[Jaypeehuda]

Hello Everyone,
I'm asking question here becuase of I did not found 'New Thread' option to create here. Actually I want to import data from different file format such as txt, csv, xls etc in MS-SQL Server. I want to know whether any option in sql server to perform such kind of action or I have to use any third party tool.
Please give me your valuable suggestion. Thanks in advance!
 

[Anthony Mangini]

that is a bad link. this is exactly what I was looking for too and was hopeful this link was good.

[Kate]

Hello Anthony,

Try using the link below:
http://stackoverflow.com/questions/375991/import-excel-spreadsheet-columns-into-sql-server-database

Kind regards,
Kate
the Telerik team