Error in importing excel sheets

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)

Error in importing excel sheets

Author

Topic

kwikwisi
Constraint Violating Yak Guru

283 Posts

Posted - 2008-12-11 : 10:36:06

I'm trying to import excel file by DTS wizard.
But i'm getting error ( "external table is not in the expected format") when i try to choose excel file.

May i know any rules or limitations on excel file for import and how can i combine all sheets into one after importing.

Thanks in advance !

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-11 : 10:40:03

does the excel contain data in consistent format?

kwikwisi
Constraint Violating Yak Guru

283 Posts

Posted - 2008-12-11 : 10:52:38

Ya..Excel is in consistent format.

But some of the cols have no value , i changed to .xls (original one is .xlsx, then i saved as .xls then import) , ms office is not installed on pc that sql server installed.
That's all.

But i dont know what's wrong.

Thanks for ur help !