![]() |
|||
Excel to SQL server DB
By: rekha singh | 10 May 2010 5:57 pm
Hi CommentsWhere is @FilePath given a value?
By: rekha singh | 10 May 2010
Check this
Exec spx_ImportFromExcel 03 'Sheet1','C: \Documents and
Settings\Avinash\ Desktop\TestUplo ad.xls',' Yes','CaseList'
Regards
By: rekha singh | 10 May 2010
I've never tried to do this, but I would make sure that SQL Server can find the file and has permission to open the file in that folder.
By: rekha singh | 10 May 2010
Hey check this link
By: rekha singh | 10 May 2010
Does SQL Server and it would appear IIS have permission to the folder? Is Jet installed on the server?
By: rekha singh | 10 May 2010
yes Installed...
By: rekha singh | 10 May 2010
Permissions?
By: rekha singh | 10 May 2010
Hey i got it done the code works fine and there was one error while executing the Procedure
By: rekha singh | 10 May 2010
|
