Import CSV file into Framework manager

[saumil287]

Hi All,
I want to know whether we can import csv file, Excel file containing report into framework manager.
I am able to import excel file containing rows and columns but could not import data from csv file.
Also I want to know one more thing whether we can import an Excel file containing multiple sheets.
please give suggestions.
yours suggestions are appreciated
Thanks and regards
   saumil

[AussiePete2011]

Hi there

I'd suggest that you do either of the following

1.  Create an ODBC connection to the CSV file and call this in to FM
OR
2.  Open the CSV file in excel, define the range in Excel and save back to excel.
     Then create an ODBC connection to this new EXCEL file.

The only other way would be using Composite or VVM as its called now

As for reading from multiple worksheets, you would either create a merged worksheet (Excel function) or call separate excel sheets into FM and join them in the model. 

Hope this helps to some extent.

[saumil287]

Hi
Thanks for your suggestion, I import the excel sheet using excel 2003.
For that we have to do Insert->name->define to select a table, but how should I do the above steps in excel 2007.
Its urgent please help
thanks in advance

[AussiePete2011]

Hi there

In Office Excel 2007 its a little different.

1.  Select "Formulas" tab from the menu
2.  Select "Define Name"

The rest of the steps are pretty much the same as 2003.

Hope this helps
Cheers
Peter B

[saumil287]

Hi Aussie,
I got it.
Thanks