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 |
|
kid_le
Starting Member
4 Posts |
 Posted - 2008-04-10 : 17:18:53
|
| I recieve this error when trying to create my sproc:Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.Here is my sql code: INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\dmhc\dfsapps\Clarify\Reports\Generated\ADT007DUMP.xls;', 'SELECT [Case ID], [HC Rec''d Date], [Case Type], [Patient/Provider Last Name],[Method Of Contact], [Complaint Category], [Complaint Type], [Complaint Details], [Health Plan],[Medical Group], [RO Determination], [Close Reason], [Close Details], [Compliance], [Summary Resolution] FROM [Sheet1$]') I'm able to create the sproc when I turn the ANSI_NULL ON but that will cause the return to drop any records that have a null value. I would like it to return all records even if there is a null value in the fields. Any suggestions would be greatly appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 22:50:17
|
| Post in Script library: Export to Excel. Madhi can help you. |
 |
|
|
kid_le
Starting Member
4 Posts |
Posted - 2008-04-11 : 11:08:25
|
| Thanks for the tip. I'll go ahead and post it there. |
|
|
|
|
|
|
|
|
Heterogenuous error when using OPENROWSET