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.
Assist with AHK to send / receive queries to MSAccess
Has or does anybody have information about working in "AHK" "Auto Hotkey" and connecting to an access database? Have found this link: https://github.com/IsNull/ahkDBA0 votes0 answersBarry Pettis1 week ago
ADO connection string to a shared Excel workbok on Sharepoint
Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.0 votes0 answerszubair Aleem1 week ago
Can't open txt files in a sql based app.
Looking for help for SQL2008 so that an app I am using can connect to SQL db as well as access data in csv text files. Do I need to change them to excel files? is that the only way?0 votes0 answersTom Jones2 weeks ago
connection string for mongodb
i build my database with mongodb and i can't find connection string format or example for mongodb0 votes0 answersAnonymous user3 weeks ago
Steps to Connect Active Directory using Alteryx OLE DB connection
Hi I am looking to connect LDAP or AD coonection using Alteryx. Please provide steps to connect to Active Directory groups using OLE DB connection via Alteryx. Regards, Anil0 votes0 answersAnil Kumar Anchuri1 month ago
connections not work in php
I am trying to connect an access 97 database from php, I have tried three ways methods and none works for me: $db = 'c:/VENTAS.MDB'; $odbcname = "ventas_dsn_sistema";0 votes0 answerscarlos col1 month ago
Oracle ODBC x86 and x84 on Excel 32bits.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(18.104.22.168) ODBC driver on my Excel.0 votes0 answersLucas Pott1 month ago
Connection string properties
Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?0 votes0 answersjos Clement1 month ago
What are steps in connecting VB.net with SQL server?0 votes0 answersMuhammad Abdullahi1 month ago
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman1 month ago
- Load more posts