ETL and Data Integration tools - Modern ETL software for everyone

I'm using this to create the test data on SQL Server 2008:

create Table dbo.export_excel_problem(
id int,
test_case varchar(max)
)
go

insert into export_excel_problem values (1, '<?xml version="1.0" encoding="utf-8"?>
<ArrayOfFilterSettings xmlns:xsi="www.w3.org/2001/XMLSchema-instance" xmlns:xsd="www.w3.org/2001/XMLSchema">
<FilterSettings> <Refnr>7001</Refnr> <IsSelected>true</IsSelected> </FilterSettings>
</ArrayOfFilterSettings>')

Table export_excel_problem can be exported to excel. But when I can't open it in Excel 2007.

You find the generated excel attached.

I can open it in excel 2003 but the cell is blank

We will have a look at this one for you

Have you tried advanced etl processor it can do more with excel export

Mike

This was addressed in latest version
+ It supports Excel 2007-2010 now

www.dbsoftlab.com/dmdocuments/DatabaseBr....1.0_English.paf.exe

3.3.1.0

Improved export to excel
GUI changes
New themes were added
Office 2003 Blue
Office 2003 Silver
Office 2003 Olive
Office 2007 Luna
Office 2007 Obsidian
Office 2007 Silver
Office 2010 Blue
Office 2010 Silver
Office 2010 Black
Windows XP
Whidbey
Windows Vista,
Windows 7
Terminal

Peter