Upload Excel sheet to table

Question

Hi I have an excel sheet it contains formulas in some cells when I'm trying to upload the excel sheet to sqlserver database table it was uploading successfully with what ever data and formulasa of cells excel sheet But I want to upload the excel sheet without including formulas. Can anybody help me on this. Regards Johnny

Vijaya Kadiyala · Answer

Hi Can you give more information on how you are uploading to SQL Sevrer?? Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

shyam kumar · Answer

Hello johny can u give the uploading excel to sql server code here for our reference thanks in advance shyam

johnny ram · Answer

it's ok but I want to do with out creating new excel sheet.

Albertto Lie · Answer

maybe i can help. 1. copy all your cell ( Ctrl-A ) 2. paste in a new sheet - WITH OPTION - value only dont include the formula 3. try import it again.