No announcements
Found 3895639 threads
-
1 Votesimport a csv file using vba
As a matter of fact, when Access exports a CSV file, I believe that it put double quotes around all fields - not just string ...Answered | 17 Replies | 32462 Views | Created by DenSolis - Tuesday, November 11, 2014 5:36 PM | Last reply by Van Dinh - Friday, November 14, 2014 4:32 AM
-
0 Votes
Quotes problem in CSV file inSSIS
I would suggest do not remove double Quotes, because data will be modified.Answered | 4 Replies | 1631 Views | Created by Ven Raja - Friday, February 22, 2013 5:34 PM | Last reply by Kostya Khomyakov - Monday, February 25, 2013 7:15 AM -
5 Votes
Removing commas and quotes from numeric fields in csv file using SSIS
It is always better to use files in XML format for any data feeds.Answered | 13 Replies | 24414 Views | Created by Khush_D - Tuesday, January 10, 2012 8:45 AM | Last reply by Nik - Shahriar Nikkhah - Thursday, February 28, 2019 2:48 AM -
0 Votes
CSV Export Double Quotes
I can now have the quotes around my all fields using the instructions above from your solutions :).Answered | 5 Replies | 10993 Views | Created by rajiv460 - Tuesday, March 10, 2015 7:54 PM | Last reply by prateek manocha - Tuesday, March 6, 2018 2:46 PM -
12 Votes
Using Oledb to read a .csv with double quotes in it
I'm not sure if that is solved by using the schema.ini file you're proposing.Answered | 10 Replies | 20413 Views | Created by Jorge Raimundo - Thursday, December 11, 2008 7:02 PM | Last reply by m00nr4k3r - Monday, June 18, 2012 3:21 PM -
1 Votes
bulk insert quote (") qualified fields
There is a class in the VisualBasic name space to read CSV file you could use.Answered | 5 Replies | 35674 Views | Created by GoodOldFashionedLoverBoy - Tuesday, March 5, 2013 7:50 PM | Last reply by Erland Sommarskog - Tuesday, March 5, 2013 11:07 PM -
0 Votes
Mapping a CSV file fields
I’m using Access 2010 on a W7 PC.Answered | 6 Replies | 611 Views | Created by KevinATF - Friday, April 20, 2018 8:07 PM | Last reply by .theDBguy - Monday, April 23, 2018 8:18 PM -
1 Votes
how to add the double quotes in csv files
Hi Abdul, You can use Derived Column Transformation to achieve your target, please refer to HomeCookN's ...Answered | 2 Replies | 1136 Views | Created by SSQL123 - Monday, August 31, 2015 12:39 PM | Last reply by Milan Das - Monday, August 31, 2015 2:19 PM -
1 Votes
CSV Help (Ignore Comma In Double Quotes)
It works well with CSV files, but I'm not sure about it reading the stream from a URL directly.Answered | 1 Replies | 2221 Views | Created by Crouchie1998 - Sunday, December 7, 2014 1:41 PM | Last reply by Frank L. Smith - Sunday, December 7, 2014 2:02 PM -
0 Votes
Remove double quotes from CSV file
However, if you plan to do more string manipulation, then I recommend using the System.Text.StringBuilder class instead.Answered | 3 Replies | 15885 Views | Created by Incredible15 - Wednesday, June 16, 2010 7:34 AM | Last reply by Incredible15 - Wednesday, June 16, 2010 3:05 PM -
0 Votes
IPython stock quotes access
Hi sail0r, It does look like access to the external site is locked.Answered | 1 Replies | 1064 Views | Created by sail0r - Tuesday, September 20, 2016 2:35 PM | Last reply by mewahl - Monday, September 26, 2016 2:23 PM -
0 Votes
replace double quotes in csv file
So here it comes: Create a string variable and set its value to double quote.Answered | 2 Replies | 4395 Views | Created by ghankot - Thursday, June 3, 2010 7:46 PM | Last reply by ghankot - Thursday, June 3, 2010 8:31 PM -
0 Votes
Setup project Creation is modifying the "Datelastupdated" field for attached files on Target machine after running the Setup.exe
But when I checked the installation of Visual Studio, which is built in Wix, I can find that some files are not modified in date.Answered | 1 Replies | 416 Views | Created by Saihemanth - Thursday, July 28, 2016 5:57 AM | Last reply by Barry Wang - Friday, July 29, 2016 9:29 AM -
0 Votes
Extracting information from "Created By" field
Hi Charles, In that case, I recommend to use SharePoint Designer workflow to achieve this goal.Answered | 3 Replies | 2040 Views | Created by Charles Lestari - Wednesday, March 16, 2016 8:48 AM | Last reply by Victoria Xia - Friday, March 18, 2016 2:14 AM -
1 Votes
SQLServerBulkCopy not working for "|" delimiter
It will help others find the correct reply directly in the Answers field.Answered | 6 Replies | 3682 Views | Created by SZZhang - Thursday, June 23, 2016 3:42 PM | Last reply by Riaon - Thursday, July 7, 2016 1:55 AM -
0 Votes
Text column with numeric values exporting to CSV without double quotes in SSRS
Therefore, if you have a field value such as: hello",world\r\n, for that value to show up exactly as it is in excel when opening up a csv file, the value ...Answered | 4 Replies | 18896 Views | Created by DDavid_SF - Friday, July 17, 2009 7:10 PM | Last reply by Ke Xu - Tuesday, July 21, 2009 9:08 PM -
2 Votes
Delete or modify a row in a CSV file
Use ReadAllLines to read the file into an array.Answered | 2 Replies | 1656 Views | Created by Ashok K - Monday, October 8, 2012 3:48 PM | Last reply by JohnWein - Monday, October 8, 2012 4:45 PM -
12 Votes
How to have SSIS escape double quotes within a string in a CSV file destination which also uses double quotes as its string delimiter?
Seems unfortunately no, then if you do not want to use my [modified] script from the post above then another approach would be still some other code to achieve the same result.Answered | 15 Replies | 45058 Views | Created by HomeCookN - Wednesday, March 7, 2012 2:04 PM | Last reply by saulcruz - Monday, July 16, 2018 10:40 PM -
0 Votes
How to Import a Comma Separated Value (CSV) File to Outlook with VBA
Sub CreateDistList() Const FilePicker = 3 Dim dl As DistListItem Dim r As Recipient Dim c As ContactItem Dim m As MailItem Dim f As Folder Dim xl As ...Answered | 3 Replies | 4400 Views | Created by Erik Heinrich - Tuesday, September 27, 2016 2:34 AM | Last reply by RLWA32 - Wednesday, September 28, 2016 3:46 PM -
1 Votes
importing a file that contains quotes (text delimiter) in a field
please refer to this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/302b1c34-0198-46b1-a748-8a5a35d5b823Please mark the post as answered if it ...Answered | 1 Replies | 2575 Views | Created by jameslester78 - Friday, February 24, 2012 10:43 AM | Last reply by SSISJoost - Friday, February 24, 2012 11:50 AM - Items 1 to 20 of 3895639 Next ›
No announcements
