| Author |
Topic |
|
ashuthinks
Starting Member
8 Posts |
 Posted - 2011-09-18 : 08:44:09
|
| http://i.stack.imgur.com/KDZ4f.pnghi I want to take value of date i.e '8/26/2011' , and value of NAV i.e '93737452.52'and want to insert into table i'm using 'excel source ' to take excel file made connection now Select 'Data access mode' in 'Excel source editor' as 'SQL command'now what command I need to write to get 'date' and 'NAV'value as I have pasted picture of excel file please let me know the further steps plese |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
ashuthinks
Starting Member
8 Posts |
Posted - 2011-09-18 : 13:22:07
|
| hi but when i do this step in 'excel source editor' in 'connection manager' i dont get proper values of 'date' and 'nav' when I do 'data access mode' 'table or view' and select that sheet because of excel file format :( thats MY PROBLEM I NEED TO DO SOMETHING LIKE SELECT THAT ROW LIKE B7 in case date please help ??? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-18 : 13:24:28
|
| hmm...whats the problem with excel format? does it have some unprintable characters before? what happens when you select sheet and preview the data?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ashuthinks
Starting Member
8 Posts |
Posted - 2011-09-18 : 13:34:38
|
| can you give me your gmail id so that tomorrow i can send you that excel file..Actually that file is having more than one sheets... laso having graphs also so when I select 'data access mode' 'table or view' and select that sheet for taking 'date' and 'nav' I can't get the preview neither values of 'date' and 'nav' I asked this on many forums they said you can directly take a value of that column so i posted my excel file 'date' values is at B7 is there any clue??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-18 : 13:37:05
|
| you mean its a kind of dashboard?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ashuthinks
Starting Member
8 Posts |
Posted - 2011-09-18 : 13:42:29
|
| somehow... please see this http://i.stack.imgur.com/KDZ4f.pngand tell me how can i get values of 'date'and 'nav'using 'data access mode' 'sql command' ? because by 'table or view' not working for me |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
ashuthinks
Starting Member
8 Posts |
Posted - 2011-09-18 : 13:47:51
|
| help me sir please I'm newbie |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-18 : 13:54:58
|
| please try the suggestion in the link------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ashuthinks
Starting Member
8 Posts |
Posted - 2011-09-18 : 13:58:27
|
| yes surely i will try this solution thank you will post my whole excel tomorrow .. also update the all possibilities which will solve my problem THANKS :) |
|
|
|
|
insert excel file data into table using ssis