Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

How to export to excel format in Connector solution 7.x ?

Created: 08 Jun 2010 | 3 comments
bkcbkc11's picture
0 0 Votes
Login to vote

Anyone tried to export to xls format in version 7 ?

I can't see any default method like version 6.x

Best Regard bkcbkc11

Comments

JeffDG's picture
09
Jun
2010
0 Votes 0
Login to vote

OLEDB Data Source

You can export to an Excel file via an OLEDB Data Source type...not very intuitive, but it works.  You can even output XLSX (Excel 2007) format files in V7

If you don't need fancy, there's always a CSV data source type.

Desmond.Low's picture
11
Jun
2010
0 Votes 0
Login to vote

I tried to export. But where

I tried to export. But where is the data save?

JeffDG's picture
12
Jun
2010
0 Votes 0
Login to vote

For the OLE Data Source you need a file

When you configure the data source, you need an excel file to point to.

Then when you point the import/export rule to that DS, and do an export, it will save the data into that file.