Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shilpash
Posting Yak Master
103 Posts |
 Posted - 2014-09-04 : 14:39:21
|
| I am getting the excel source in xls file.When I load this using version 97-2003,many columns get null and if I switch it to excel 2007 version in the drop down I don't have this issue.But the problem is I am getting the source using the variable filename.eg filename=c:\abc\xyz.xls.I am passing this value to the excel path.When I load this file without using the variable using 97-2003 and with excel 2007 version I don't have any problem in loading.But then after initially loading the file in 2007 version,Now I change the excel connection using the variable filename pointing to excel file path,I will have issues but not issue with 97 version.'Check that object exists in the db'.Please help.Thanks in advance |
|
|
shilpash
Posting Yak Master
103 Posts |
Posted - 2014-09-09 : 11:21:33
|
| this is solved.Thanks |
 |
|
|
|
|
|
Issue with excel version number