Error while uploading Excel TO SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Error while uploading Excel TO SQL

Author

Topic

vimaldreams
Starting Member

17 Posts

Posted - 2010-11-19 : 09:45:00

Server Error in '/' Application.
--------------------------------------------------------------------------------

Could not find a part of the path 'C:\Documents and Settings\vp\My Documents\Visual Studio 2010\Projects\MeadeKing Database\MeadeKing Database\Files\Test.xls'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Documents and Settings\vp\My Documents\Visual Studio 2010\Projects\MeadeKing Database\MeadeKing Database\Files\Test.xls'.

Source Error:

Line 35: string FilePath = Server.MapPath(FolderPath + FileName);
Line 36:
Line 37: FileUpload1.SaveAs(FilePath); Error Showing here
Line 38:
Line 39: GetExcelSheets(FilePath, Extension, "Yes");

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-11-19 : 10:12:06

Not much to go on but it's saying that it can't ind the directory.
Common reasons are

Path is on a different machine - may be executed at the server and the path is on the client
spaces in the path need to be escaped/encapsulated
The path is wrong

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources