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
 Script Library
 Issues exporting data from SQL 2005 to excel

Author  Topic 

BHari
Starting Member

2 Posts

Posted - 2007-08-28 : 01:20:59
Hi
Im using the SQL SERVER MANAGEMENT STUDIO. and when I try try to export the data to excel using the import/export wizard, I get an error saying
'external table is not in the expected format (MICROSOFT JET database engine)'
can someone tell me what is this error due to??
Also, please let me know where I can find details about the MS JET database..I hv no idea on that one.

B

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-28 : 01:46:53
Are you trying to export to MS Excel 2007 format?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -