No announcements
Found 3641419 threads
-
2 Votes
Function to Import Excel Data to dataset in C#
Hello, For import excel data in C# you may use a 3rd party component.Answered | 17 Replies | 82012 Views | Created by Javed Ahmed - Sunday, July 22, 2012 5:42 AM | Last reply by Tim Grey - Sunday, February 17, 2019 2:18 AM -
2 Votes
Importing a Csv File using SISS
I am importing a tab delimited file and get this error .Answered | 2 Replies | 3011 Views | Created by SSIS User2011 - Friday, January 13, 2012 5:37 PM | Last reply by Nik - Shahriar Nikkhah - Friday, January 13, 2012 8:15 PM -
0 Votes
importing multiple csv files into sql
In SQL Server Express Edition you can either use plain T-SQL or the Import/Export Wizard to import data; with both you can only import one file after the ...Answered | 2 Replies | 949 Views | Created by AlexMartini - Monday, October 17, 2016 9:59 PM | Last reply by Olaf Helper - Tuesday, October 18, 2016 6:19 AM -
0 Votes
Importing .csv file where file name changes
The previous day files will remain in the same folder as today's csv.Answered | 6 Replies | 4437 Views | Created by Diango - Monday, June 30, 2014 10:43 PM | Last reply by ryguy72 - Tuesday, July 15, 2014 10:17 PM -
3 Votes
Importing csv files using a stored procedure
Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to youAnswered | 4 Replies | 57267 Views | Created by pscorca - Monday, May 28, 2012 6:28 AM | Last reply by ryguy72 - Monday, June 25, 2012 11:02 PM -
1 Votes
Importing a CSV into Data Grid
" I'm familiar with both usages, especially back in the days before there was any such thing as a .CSV file.Answered | 12 Replies | 1000 Views | Created by NepaGwark - Thursday, June 12, 2014 3:19 AM | Last reply by Frank L. Smith - Friday, June 13, 2014 1:01 AM -
2 Votes
Imported csv file and quotation marks
you can use a script to clean the file via VB.Answered | 2 Replies | 5058 Views | Created by NCooper - Wednesday, April 28, 2010 2:27 PM | Last reply by jon285 - Wednesday, April 28, 2010 2:36 PM -
1 Votes
Importing CSV File into a Datagrid, THEN to a database...
Hammed Silva has found solution while seeking for help.Answered | 12 Replies | 4056 Views | Created by H. Silva - Monday, November 15, 2010 5:03 PM | Last reply by H. Silva - Thursday, December 2, 2010 6:50 PM -
0 Votes
Validating CSV File BEFORE importing and moving using an SSIS package
The file connections let me change the path in the package configuration, but since the for each loop doesn't use a file connection I don't know how to change it.Answered | 7 Replies | 5959 Views | Created by steveman2292 - Thursday, March 20, 2014 1:44 PM | Last reply by Mike Yin - Friday, March 28, 2014 8:34 AM -
0 Votes
Importing Termsets from CSV file into termstore
Hi praveen, Please check the following article about importing many Termsets in one CSV file into ...Answered | 3 Replies | 3644 Views | Created by praveen sharepoint tech - Monday, June 25, 2012 4:30 AM | Last reply by star.wars - Tuesday, June 26, 2012 3:14 AM -
0 Votes
Importing CSV files with variable rows
Hi Bob, use the Conditinal Split Transformation to generate a set of three flat files and operate on each to process according to the logic.Answered | 2 Replies | 2410 Views | Created by Iowa Bob E - Wednesday, February 22, 2012 8:41 PM | Last reply by Todd McDermid - Wednesday, February 22, 2012 10:57 PM -
0 Votes
How to import CSV files from a HTTP location
Hi, I am trying to import a CSV file from a HTTP location.Answered | 2 Replies | 4168 Views | Created by WPF Fan - Tuesday, March 31, 2009 1:52 AM | Last reply by COZYROC - Wednesday, July 8, 2009 11:15 PM -
0 Votes
Display datagrid from imported CSV file using powershell (Monad)
$array= new-object System.Collections.ArrayList $data=@(Import-CSV "C:\Scripts\Test.csv"| ...Answered | 3 Replies | 19592 Views | Created by ME5555 - Thursday, June 25, 2009 9:06 PM | Last reply by Cyreli - Saturday, April 21, 2012 6:06 PM -
0 Votes
How to convert Excel file in csv ?
Yesterday I found a solution, by using JET provider and making a flat file.Answered | 10 Replies | 4109 Views | Created by KiaraFR - Wednesday, December 14, 2011 1:57 PM | Last reply by KiaraFR - Friday, December 16, 2011 8:58 AM -
0 Votes
Failed to import csv data file
Import data . than i see the sample data is incorrect?Answered | 12 Replies | 946 Views | Created by Tan_100 - Tuesday, January 22, 2019 5:20 AM | Last reply by Visakh16 - Wednesday, January 23, 2019 10:51 AM -
0 Votes
How to remove last row in csv while importing - using tsql
Hi All, Thanks for ur inputs - one thing which i wanna do is - to do this using t-sql and not any other means i acheived the same by ...Answered | 8 Replies | 6323 Views | Created by RMNathan - Wednesday, May 2, 2012 7:17 PM | Last reply by Uri Dimant - Tuesday, June 12, 2012 9:34 AM -
0 Votes
PowerPivot CSV import
As we know, the provider used for importing text or csv files is the ACE provider from Microsoft Access , the provider may have some limitations (eg. 255 columns) ...Answered | 1 Replies | 4568 Views | Created by Skymiga - Wednesday, May 24, 2017 11:46 AM | Last reply by willson yuan - Thursday, May 25, 2017 3:41 AM -
2 Votes
Import CSV file where column headers are in the row
You are constantly busy like if you have a CSV file, ignoring what I wrote about that an CSV file has a very strict description.Answered | 16 Replies | 13786 Views | Created by tmacdonaldmpower - Tuesday, August 31, 2010 12:08 AM | Last reply by tmacdonaldmpower - Friday, September 3, 2010 1:31 PM -
1 Votes
Import/Exporting csv's (Wizard or Not?)
you can use bulk insert, bcp commands or SSIS packages to import data from the sources.Check the below links fro more information.Answered | 1 Replies | 685 Views | Created by SimonKEvans - Wednesday, September 28, 2016 11:49 AM | Last reply by Vijaysys - Wednesday, September 28, 2016 12:06 PM -
0 Votes
CSV importing unwanted columns
Is there not anyway that I can do it but still using the flat file connection manager?Answered | 14 Replies | 8106 Views | Created by wattyjnr - Wednesday, April 13, 2011 10:43 AM | Last reply by wattyjnr - Thursday, April 14, 2011 11:47 AM
No announcements