Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
holguinmora
Contributor III
Contributor III

Store Function

Hi to all!!!

I´m having a small problem using the store function, on the next image the content of a table, then the script that I´m using to export the table to a CSV file and finally the error that I´m getting when I try to open the file with excel to validate the info.

Any help? Any ideas?

Captura de Pantalla 2019-07-09 a la(s) 5.09.23 p. m..png

Script:

[B]:
LIB CONNECT TO 'Dropbox - alejandro@inflexion.com.co';

LOAD
CodigoB,
NombreB
FROM [lib://Dropbox - alejandro@inflexion.com.co/Pruebas/Libro B.xlsx]
(ooxml, embedded labels, table is Hoja1);

store [B] into [lib://Prueba Destino/Tabla3.csv (txt)]

Excel error: 

Captura de Pantalla 2019-07-09 a la(s) 5.36.37 p. m..png

 

Labels (3)
1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi Holguinmora,

You are able to store and don't store into Dropbox itself? How big in the csv file that you are trying to open?

Jordy

Climber

Work smarter, not harder

View solution in original post

2 Replies
Lisa_P
Employee
Employee

try removing the txt.

..

store [B] into [lib://Prueba Destino/Tabla3.csv];

JordyWegman
Partner - Master
Partner - Master

Hi Holguinmora,

You are able to store and don't store into Dropbox itself? How big in the csv file that you are trying to open?

Jordy

Climber

Work smarter, not harder