CSV file decimal value issue
I have a csv file with multiple columns. Some columns have numeric data with decimal having 2 to 10 decimal accuracy. When reading this file from ADODB record using VBA some column decimal values are getting picked correct but for some its only taking number (without decimal).
Column 1 value = 26.0123456789 (value can vary)
Column 2 value = 26.0123456789 (value can vary)
In the record object the value for column 1 is coming as 26.0123456789 but for column 2 is coming as 26
Using connection string as:
con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Directory_Path & ";" & "Extended Properties=""Text;FMT=Delimited(,)"";"
Have you tried putting a schema.ini file in the folder.
It can contain specifications about your data.
[Data.csv] ColNameHeader=true MaxScanRows=0
MaxScanRows with value 0 in this case would cause the datatype guessing to scan all rows in the file.
Thanks for the reply. Yes I tried that yesterday and it worked like a charm. I went busy with other stuff so could not update here.
Thanks a lot for replying.
VFP need MSXML2, 4.0
I have loaded VFP9 with SP2 on 64-bit Win-10. It seems to work correctly since I do not have intricate programs, just related databases. With every log-in I get a message: 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found.0 votes0 answersKatharine Cipolla1 day ago
Loading dbf Foxpro file from Excel VBA Project
Hi there: I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user.0 votes1 answerKlueze2 weeks ago
Connect a VbScript to MySQL without ODBC driver
Hi everybody, I'm just beginning with MySQL and I try to make a connection between a VBscript and a MySQL Database.0 votes4 answersJean-Marc CADIOU2 weeks ago
Run control Informix Linux_6.9 & Linux_7.6
I'm starting informix I'm db2 of db2, I have to schedule script to run control to restart the database of handles contralada, I do not know how to look for something ?? , I thank you in advance0 votes0 answersMARIA DEL CARMEN NANDAYAPA RIZO3 weeks ago
Basic4Java connect to Sql Server
How connect to SQL SERVER with Basic4Java and what driver to use.0 votes0 answersRoberto Alonso3 weeks ago
Troubles with firebird 1.5 connection with c# and FirebirdSql.Data.FirebirdClient.dll
Link Greenleaf a través de googlegroups.com 14:14 (hace 8 horas) para firebird-net-provider Hi, Im trying connecting to a Firebird Database 1.5. with FirebirdSql.Data.FirebirdClient.dll in c# VS20150 votes0 answersLINK GREENLEAF3 weeks ago
VBA update sharepoint inserts
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).0 votes3 answersThe Dinos3 weeks ago
External table is not in expected format
Microsoft odbc driver external table is not in expected format. What is the root cause of the issue Connection string used is Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path0 votes1 answerAnonymous user3 weeks ago
SQL advantage ODBC connection
I am trying to connect to sql advantage to a application(uipath) using ODBC driver. I have the driver installed in my system. My Question: 1. Do we need to add that driver in DSN for sure?( I tried a lot but getting error: database server not found).0 votes0 answersRamesh Garimella1 month ago
ADO connection string
I need a ADO connection string to work with Quick Payroll, I am not a developer but I need it in order to customise reports.0 votes0 answersAnonymous user1 month ago
- Load more posts