Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>>>Try adding NOFILTER in your select statement and TYPE XL5. Also, did you verify that the file contains data?
>>
>>Changing to XL5 fixed the problem. I did not have to type NOFILTER. Thanks!
>>
>>Interesting - the XLS worked on my machine (Win 7), but not on the other (Windows Server 2008 R2 Standard).
>
>NOFILTER is a must in your situation because you're selecting all the columns and using a where condition. It may result in the filtered result.
While I agree with you about the use of NOFILTER (except I always use READWRITE) I don't think it's relevant to Yossi's problem. If the COPY TO didn't respect the filter condition (although, as Tore says, I expect that it always should) wouldn't the result be the entire source table, not just the filtered records?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement