SQL select from a file

Asked Feb 16 '22 at 14:30

Active Feb 16 '22 at 14:37

Viewed 43 times

Is it possible to execute a select from a file? I have tried the following but without any luck.

Query:

SELECT E_MailL 
FROM OCPR 
WHERE (CardCode) IN ('c:\temp\test.txt')

The file contains the customer code per line eg

CustomerCode1
CustomerCode2
CustomerCode3

Any advice or samples are welcome.

Database is SQL Server 2017.

edited Feb 16 '22 at 14:37

marc_s

asked Feb 16 '22 at 14:30

Alain Seys

What's the database? – The Impaler Feb 16 '22 at 14:33
'c:\temp\test.txt' in the context is a string literal. The query will return rows where CardCode is equal to that literal. – Serg Feb 16 '22 at 14:34
This may help... https://stackoverflow.com/questions/2007857/reading-a-text-file-with-sql-server – Isaac Feb 16 '22 at 14:37
2

`OPENROWSET` is what you want; then you can `JOIN` to the data returned from it. – Larnu Feb 16 '22 at 15:01
@Larnu thanks that worked with some modifilcation i added a fromatting file to catch the whitespaces. Thanks for the help – Alain Seys Feb 16 '22 at 18:41

0 Answers0