Data From Excel to Sql

  • Thread starter Thread starter pushpendra vats
  • Start date Start date
P

pushpendra vats

Hi!!
I have a small problem...
I have data in excel and want to excess it convert into
sql table with certain validations .How to do it...
Any help..

Thanks

Pushpendra
 
Hi Pushpendra,

I think you can start to read it in a dataset, however than you are not
ready.

Because you do not know what is in your excel file on doubles, new etc, you
have to process it.

That can be in a lot of ways depending on your, however I think for that is
the simplest way looping through your excel dataset.

A connectionstring you find for that here

www.connectionstrings.com

Cor
 
Hi Ken,

It was no critique, only to attent you on this

Transfer Data * to* an Excel Workbook by Using Visual..................

Cor
 
Back
Top