Hello,
I'm using ADODB to import a CSV file in Excel. I have done this many times (almost) without any problem. However now I have a csv file that has double quotes around each value. It turned out I have never had such case before. Any ideas how to import it correctly (i.e. without the quotes)? I assume it would be something in the connection string (extended properties?)...
Of course I can always use the import from text feature but would prefer the ADODB approach.
Thanks in advance.
If you are pleased with a member's answer then use the Star icon to rate it.
Have you tried FMT=Delimited?
https://msdn.microsoft.com/en-us/lib...or=-2147217396
https://www.connectionstrings.com/textfile/
Please provide examples of the form of data that is causing you grief (look at the CSV using Notepad), and explain what problem it causes. Also, what version of Excel are you using?Originally Posted by buran
There should be nothing wrong with putting double-quotes around everything. But Excel strips off double-quotes around numbers (including dates, percentages, currency; perhaps other numeric forms) and treats them as numbers, not text. I don't know what ADODB does.
Excel also strips off double-quotes around non-numbers and treats them as text. But I encountered a surprise with Excel 2007. (I usually use Excel 2010.)
@Keneth Hobson - thanks, that worked.
@joeu2004 - if you don't know what ADODB does, please, don't add spam to the thread. :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks