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  SQL Server 2005 Forums  SSIS and Import/Export (2005)  excel is not importing into an application

Author  Topic  sql2k8 Starting Member 3 Posts Posted - 2010-05-12 : 11:44:13 when i load an excel sheet into the application. it is not getting uploaded .it tells to me that it is an invalid spreadsheet. i had created a table in EXCEL and i had loaded the data into the excel using ssis. is there any way the user can import the data from excel to the appplication with out opening and saving the excel sheet. if the excel is opened and saved then the excel gets loaded into the application. but i dont want that.