Export Excel to Sql Server 2005

hpjack433 · April 1st, 2009, 01:54 PM

I am trying to export the excel to sql server table. I wrote a piece of code that is helping me in exporting the excel to one of the table...

the problem is, incase if i have just two columns in excel, and 5 columns in sql server table, i am getting an error..."No value given for one or more required parameters."

if it were two columns in excel and two columns in sql, its exporting wid out any problem....

i think i made my point.....cud u guys help me out there....

would be eagerly waiting for your replies

hpjack433 · April 2nd, 2009, 07:37 AM

so there is nobody who can help this poor soul??
i had lot of faith in this forum.....i need the solution ASAP.
would be eagerly waiting for your kind responses dudes

hpjack433 · April 3rd, 2009, 01:06 PM

thx a lot forum members....
i was able to resolve my problem from asp.net forums