Upload excel/csv file to database using VB.Net

[nelco]

Need to upload data from excel/csv file into SQL Server database using VB.net. Any ideas how this can be done? Any help would be appreciated?

 

[RiverGuy]

Why do you need to use VB.Net? I would use SSIS/DTS. If need, you can call an SSIS package from VB.Net.

 

[nelco]

This needs to be done in an application (i am using VB.net) where in the user can upload the file which gets put in the database. Since I am new to VB.net, I wasn't sure that we could call SSIS package from VB. If possible, could you tell me how to do this or point me to any resources which would help?

thanks a lot.

 

[RiverGuy]

If the end user doesn't have SQL tools installed, I'm not sure that it will work as they will not be able to reference the SSIS libraries.

Another option is to use BULK INSERT

http://msdn.microsoft.com/en-us/library/ms175915.aspx

Other than that, there is not really simple way to do this in pure .Net. I would probably start out by using a text driver to create a connection to your text files, reading the data into a DataSet. Next, loop through the DataSet and DataTables and execute SqlCommands against your DataRows while validating your data.

 

[Ajb2528]

nelco,

You could try out the stuff on these links -

http://www.codeproject.com/KB/database/filehelpers.aspx

http://www.codeproject.com/KB/office/ExcelToDataset.aspx

to download the samples you need to register - but its free!

Regards,

Alan