Sql select from file

So I thought it may be a little easier to read this list of IDs from a text file, bulk insert the IDs into a temporary table, and perform a sub-select in the where clause. You can also generate a package like this from SSMS on the fly by right clicking on database going to tasks then import date and setup excel as source file. If you have them in Excel or I supposed even the txt file you can also create a linked server.

Also the file will have to be an accessible path for I believe both yourself and your sqlagnet. And here is how you can select from the data once you have created the linked server. Note the file cannot be open! Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Reading Data from. If yes then what would be the SQL command for it? Tomalak k 64 64 gold badges silver badges bronze badges.

Add a comment. Active Oldest Votes. You always have those great ideas contradicting what I thought was the truth My friend, this is simply an awesome answer! I didn't figure you had anything left to learn my friend! What you could do is this: bulk load your employee names from the text file into a temporary table then do a JOIN between your dbo. EmployeeID, e. Salary FROM dbo.

EmployeeNames en ON e. Let me try this. First, the CSV file. In addition, it has a very simple structure, because the characteristic features are values in rows separated by commas. The rows that follow contain values corresponding to the column headers, separated by commas. The popularity and the wide acceptance of this format allow for the exchange of data between different platforms and applications. You can export data from one database and import them into other software like Excel.

This independence also allows moving data between different operating systems like Windows and Linux. Companies working with data on different platforms can operate on the same data and move data by using the CSV format to import and export. The CSV format also provides an easy way to understand data because it is human-readable.

When we run it, all data is displayed in the SQL output window. But what if we want to see the same data in other applications like Excel? Read on to find out several methods for exporting data from a table to a CSV file. There are several different methods to do so. First, run SSMS. In the next step, expand the Database node and right-click on your database that contains the table product our database is store. Fill other fields like the name of the server, login, and password to the server, and choose the database storing the table you would like to export our table product is in the database store :.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.