Hi All,
I am facing this weird problem of partial data being fetched when using oledbadapter for fetching data from a Excel spreadsheet. A few cells containing text values are not being fetched..I get an empty string. When i replace this text value by an integer, the problem is no more a problem...
Anyone having faced this problem or having knowledge about this..pls respond..
Thanks in advance
I'll recommend the use of DTS. then
create an SP that triggers the DTS thru xp_cmdshell using dtsrun.
call the SP from the application
No comments:
Post a Comment