InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:38:35 GMT20http://www.sqlservercentral.com/Forums/Topic1426233-8-1.aspxYou say you choose Excel 97-2000 and locate the file. Does that mean the file already exists? If so, is it in the 97-2000 format (I mean, is its extension "xls" and [b]not [/b]"xlsx")?Wed, 06 Mar 2013 18:15:16 GMTjohn.arnotthttp://www.sqlservercentral.com/Forums/Topic1426233-8-1.aspxHithis is what im trying to do;I have a sql server as followWindows server 2003SQL server instance 200032 bit i presumei open import and export data --> on destination i choose excel 97-2000 and i locate the excel file, just when i hit next this error comes upError Source: Microsoft JET Database engineError Description: External table is not in the expected format.I'm knocked out.Wed, 06 Mar 2013 02:22:13 GMTshani19831http://www.sqlservercentral.com/Forums/Topic1426233-8-1.aspxWithout all the details, it's hard to say anything definitively, but you're on the right track asking if Office has to be on the server. The server needs the proper provider software and if you had Office on the server, it would be there, but that's not necessary. You can instead install the Office 12.0 engine or (for older Excel) the "Jet" provider (see link below). If it is an xlsx (Excel 2007) file, you're NOT connecting to the type of Excel that SQL 2000 knows about, and you need to establish an OLEDB connection. The "Server" connection has an optional drop-down from which you can select a new connect of "Microsoft Office 12.0 Access Database Engine OLE DB Provider". If you have Office on your machine, you'll see this, but you also have to make sure the provider is on the server where the package will run. Configure it under the "Properties" button with the file name in the Connection tab and Extended Properties on the "All" tab as "Excel 12.0".Take a look at this MSDN article. Even thought its domain is SQL 2008, the concepts still hold -- you need the proper provider. [url]http://msdn.microsoft.com/en-us/library/cc280527(v=sql.105).aspx[/url]Tue, 05 Mar 2013 19:19:42 GMTjohn.arnotthttp://www.sqlservercentral.com/Forums/Topic1426233-8-1.aspxHi GuysI have created several DTS packages, and the data gets stored in csv flat file and get mailed automatically.Now i wanted to created the same but this time save the data in excel file but this is the error i receive when try to choose destination file:[b]Microsoft database engine external table is not in the expected format[/b]I have searched the web but couldn't find a satisfactory answer.Do i need to have office installed in my sql server box?Thank youMon, 04 Mar 2013 07:15:32 GMTshani19831