LeoM's latest activity
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Just to clarify the scope of all of this, maybe there is another solution: actually I'm forced to prepare a CSV template file because it...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Sorry, but i believe i don't understand you. This is the original query from the database, data are stored as it is showed. What do you...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..If it can help, following is my query result which I use to export in CSV with the following instruction: Docmd.TransferText...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Good morning everyone and thanks for all answer. Attached is part of my data who I usually export from MS ACCESS (trough query) in CSV...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..I did this test, when i import the CSV file previously created, the values are showed ok. Only when i export in CSV are wrong, or better...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Yes, the code work fine but those values are always "wrong", i mean are written with "+". LCM IT T22_DN150X100_CL300 2.203E+12 LCM...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Thank you. Does it work with CSV ? because i tried to add this code but to create CSV (instead of txt) but when it goes trough the loop...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Yes not possible to specify, i have only list of fields not possible to change any type.
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..I usually create specification when I import (with wizard) but how i can do when i export , i don't have even the possibility to save in...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..I work as CMMS of an Oil&Gas company so in general with all discipline, including Piping yes.
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Surround the number with ' you mean in the query like : "'" & [Field] I tried and i got the same
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..Yes the number is there i can see it, however there is a team that take my CSV template and check the data in the file and they find...
-
LLeoM replied to the thread Data Change in CSV file after TransferText data export..In my table the field (Model Number) is a Short Text type not a number but it seams in the CSV is transformed in a number.
-
LGood morning everyone. I'm actually use a simple function to export some data trough a selection query to a CSV File. The problem is...