August 26, 2009 at 4:40 pm
Hi Everyone,
I need an urgent help on loading Sql Server Table data into excel 2007 Workbook. The Source Table has several columns and among them one is "TYPE" COLUMN. The possible values in TYPE Field are 'A' , 'B' and 'C'.
I have three queries to bifurcate the data and I need to load the data coming from three queries into 3 different worksheets of same workbook. Everytime I run the package the sheets should delete the records which are already there in worksheets and it should load the worksheet with fresh data from row 1.
Any help would be appreciated.
Note: The data should get loaded into different worksheets of a workbook and it should get loaded into excel 2007 only.
I am using Microsoft access 12.0 provider and still I am unable to do that.
Thanks,
sai
August 27, 2009 at 3:12 pm
If any one let me know what are the equivalent datatypes need to be used in comparision to sql server nvarchar,float,varchar,int,decimal datatypes in excel 2007.
The data gets loaded for some records and for some records few columns data is blank.
Please let me know if anybody have any suggestions or advises on this.
Thanks,
Sai
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply