Hi I'm completely new to SQL and need some help with a very specific problem.
I have a .db file that contains a table with two columns. One column is for IDs, and the other column is a text field for each ID.
Using DB Browser for SQLite, I can extract the data from a text field and output it to a .txt file individually, but I need to do this for every item in the text field column. Can someone help me with an SQL script to select every item in the text column, and output the data to a separate .txt file for each individual item?
This is a SQL Server forum and you may get better help from a forum that is specific to SQLite. However, I have something laying around that will do that using PowerShell so I will share.
I created a SQLite table with two columns: Id and Description. The PowerShell script will open the database, select the data from the table, and output to file with a name based on a value in the column. Probably not the best example of PowerShell but it works.
This assumes a lot of paths so change to meet your needs.
Yeah, you will have to download the SQLite libraries from their site. I should have mentioned that. I based a lot of that off an excellent article you may be interested in.
I downloaded the Precompiled Binaries for 64-bit Windows (.Net Framework 3.5 SP1). You will have to get the one for your OS and what is supported on your system.