Stack Overflow
Stack Overflow

Questions tagged [export-to-text]

82 questions
68
votes
4 answers

DBeaver, export from database Postgres, table structure (properties) into file .txt

I have little problem with DBeaver. I want to export my structure from each table from database in file .txt. I found how to export all data but I don't need this data, just table structure. If you have some solutions for export table structure .csv…
Iani M.D.
  • 783
  • 1
  • 6
  • 7
14
votes
6 answers

SQL Server : export query as a .txt file

I am trying to export my SQL Server query results into a folder in .txt format (this is for an automated job) I know the equivalent in MySQL works with INTO OUTFILE. Does anyone know the best way to do this in SQL Server 2008 Management Studio?…
SRahmani
  • 348
  • 1
  • 5
  • 17
5
votes
2 answers

Loop through Excel worksheets and save text into a TXT file with C#

I have most of the problem solved. I can loop through the worksheets, I can create the text file and write to it. The only problem I'm having is actually extracting the text or values from every sheet. Below is the code I have, but it only throws an…
sergeidave
  • 662
  • 4
  • 11
  • 23
5
votes
4 answers

Is there a way to export powerbuilder application to text?

I want to start controlling our inhouse applicatoin using Git. And I thougth that if I can export all the application to text (not exporting object by object) and then using Git in them. And of course I will need a method to import this text files…
Aragorn
  • 843
  • 12
  • 25
4
votes
3 answers

Excel to Tab delimited (.txt) file with special character

I want to export Excel to Tab delimited (.txt) file with special character. I've changethe format to UTF-8, but it still doesnt work. The origin data is like Mädchen and what i got is M?dchen Anyone can help me? Thank you
TrueBlue10
  • 318
  • 2
  • 4
  • 16
3
votes
1 answer

Export Google spreadsheet to text file using script

I have a Google spreadsheet file containing just one sheet with one column. Everytime it is changed, it should be saved as a simple text (*.txt) file on my Google drive. So I would use the "on edit" trigger to run the script. I found a few scripts…
AlexSell
  • 41
  • 1
  • 3
2
votes
2 answers

Exporting SQL query from Python to txt file

I'm trying to export data that I queried from a database to a txt file. I am able to do so with the .to_csv method however it exports with spaces. I've tried to set the (sep) in the query to no space but it is forcing me to use at least one space or…
adura826
  • 103
  • 1
  • 1
  • 10
2
votes
1 answer

Solve runtime 91 error in Excel VBA textfile export

Very new to VBA and trying to create an automated textfile export. Currently it works like a charm for row 1 and the textfile is created. But when adding data on row 2 as well I get: Runtime error 91, Object variable or With block variable not…
roobeat
  • 21
  • 1
2
votes
6 answers

C# Save DataGridView to Text File

I'm currently attempting to use datagridview for the first time, I have managed to do many things with it so far (such as importing text files) however, I have trouble when attempting to save the datagridview's contents to a text file. The output…
ACƎ
  • 23
  • 1
  • 1
  • 3
2
votes
2 answers

Getting an Extra Empty line when exporting Excel Range to .txt file

I am trying to copy an Excel range to a .txt file. The export is successful, with one exception, It adds one "extra" empty line at the end. I've read and tests many of the solution on SO (and other sites), but still without any success. My Code…
Shai Rado
  • 33,032
  • 6
  • 29
  • 51
2
votes
2 answers

Access export query as text with header and footer

I've been researching this issue high and low for an answer or at least a template to go by. I am using MS Access 2007. I need to export a query as a text file with fixed width specifications (already done). The problem(s) I am running into, is that…
PAT2B
  • 21
  • 2
2
votes
1 answer

Using BCP in a SQL query

I have a stored procedure that updates several columns in a table and then selects out those columns so I can save them out for a report I run. Currently I am doing the exporting and saving manually though by setting column size in 'Query Options'…
Jared H
  • 49
  • 1
  • 2
  • 5
2
votes
2 answers

Export separate texts files from list in R

I have a large list of 4951 named elements. Each of these elements are basically letters (that is, they are string characters). What I would like to do is to export each of the elements of the list as a separate text file, with the name of the file…
JoeF
  • 733
  • 1
  • 7
  • 21
2
votes
1 answer

VBA Export Excel Range to specific directory and file name

I have an Excel worksheet from which I need to export range, A:1 to last used cell in column A, to an xml file. How do you set the exported file name to be the same as the file I exported from? Sub exportxmlfile() Dim myrange As…
user1906902
  • 23
  • 1
  • 4
2
votes
1 answer

export content to a text file using java with save dialog

i have a result set which has got some values, i want to export the data which is there in result set as a text file with the save dialog. how to do this in java?. I have done the above requirement for excel and java like the…
Java Questions
  • 7,813
  • 41
  • 118
  • 176
1
2 3 4 5 6