This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 28.999999999999996%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Hola consulto si me puede brindar alguna solución, necesito exportar una consulta de sql a un archivo de texto, (eso lo genero sin problemas) pero necesito cambiar el formato con el que me guarda la info en el archivo de texto.
*En el Sql utilizo
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=C:\PadronExcel\Csv\;HDR=YES;FMT=Delimited(;)','SELECT * FROM test.txt')
SELECT top 20 object_id, name
FROM sys.tables;
y la info en el archivo de texto me sale de esta manera, necesito que me exporte sin comillas dobles y separado con ;.
*Archivo txt
object_id, name
"6616158","Inmunios"
"8660120","Nomenclador"
"16055143","Re"
"18984040","Socios"
"20364033","Inmu"
This is an English spoken forum and please write your post in a readable way.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
As Olaf says, this is an English spoken forum. If you use other languages, it makes your description difficult to understand.
Change information output format when using Microsoft.ACE.OLEDB.12.0
Hello, sorry, I am wondering if you can provide me with a solution, I need to export a sql query to a text file (I generate it without problems) but I need to change the format in which the information is saved in the text file.
*In Sql I use
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=C:\PadronExcel\Csv\;HDR=YES;FMT=Delimited(;)','SELECT * FROM test.txt')
SELECT top 20 object_id, name
FROM sys.tables;
and the info in the text file comes out like this, I need it to be exported without double quotes and separated with ;.
object_id, name
"6616158","Inmunios"
"8660120","Nomenclador"
"16055143","Re"
"18984040","Socios"
"20364033","Inmu"
La lengua de ese forum es inglese.
If you go by the INSERT OPENROWSET route, you are quite much in a straightjacket, I think. You get what you get.
I think you should use BCP instead which offers more degrees of freedom.