Recent content by LeoM

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 is required by the SAP functional team who upload data into the system trough a program who read the CSV File. So, as i explained, i export my data from my ms...

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 mean when you say that are not consistent, format is the same, we speak about technical data which is normal are like that. Honestly i don't understand where is...

If it can help, following is my query result which I use to export in CSV with the following instruction: Docmd.TransferText acExportDelim, , "008_EQUI_Temp", myfilename, True The records which are wrongly transformed are in the column "ManufSerialNo" in red color, all the others are well...

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. The problem is in the column "Q" (ManufSerialNo) for those 3 very long numbers. Cheers

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 are visualized wrongly :unsure:

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 IT T22_DN50X40_CL300 2.203E+12 LCM IT T22_DN150X100_CL300 2.203E+12 Any other idea ? Cheers

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 is close immediatelly, probably because the file is empty. Any idea ? Cheers

Yes not possible to specify, i have only list of fields not possible to change any type.

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 CSV, only XLSX or similar and don't give me the possibility to choose the specification. Sorry don't know how to do it.

I work as CMMS of an Oil&Gas company so in general with all discipline, including Piping yes.

Surround the number with ' you mean in the query like : "'" & [Field] I tried and i got the same

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 duplications in this way so i need to also show as it is. I tried the 2 way suggested by arnelgp but in both cases i got the same. How to export as string ? By i...

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.

Good morning everyone. I'm actually use a simple function to export some data trough a selection query to a CSV File. The problem is that when i export the data from my table (trough query) in the CSV output file i have some values (long numbers) who change. See please below : This is part of...

Absolutely no. In the FE database, which is deployed, tables are linked to the BE which is one for all.