No announcements
Found 3472414 threads
-
8 VotesCopy Table from another table
Here's how:Suppose you're trying to copy the authors table of the Pubs SQL Server database with data and structure.Answered | 8 Replies | 80227 Views | Created by Muralidharan - Monday, May 16, 2005 7:38 AM | Last reply by Khilitchandra Prajapati - Friday, July 13, 2012 1:56 PM
-
1 Votes
Loading .CSV files data into SQL database table.
I need to extract data from .CSV files and load into SQL database Table using SSIS 2008 or 2005.Answered | 2 Replies | 6116 Views | Created by Jeevan Dasari - Tuesday, February 22, 2011 2:01 AM | Last reply by Jeevan Dasari - Tuesday, February 22, 2011 6:04 AM -
0 Votes
Using OpenXML how do we copy data from .csv file to existing excel
Hi Sudha You'd need to use text parsing tools to "read" each item in the csv file and "transform" it to the Excel Open XML.Answered | 1 Replies | 2287 Views | Created by SudhaMarothu - Wednesday, September 9, 2015 12:06 PM | Last reply by Cindy Meister MVP - Wednesday, September 9, 2015 6:37 PM -
1 Votes
How to load CSV file into the temp table on fly?
Hello - You can use the following code: -- First Example: Here file1.csv is having two columns EmpID, EmpName SELECT * INTO tblX FROM OPENROWSET ...Answered | 1 Replies | 9669 Views | Created by Incredible15 - Friday, June 19, 2015 3:21 PM | Last reply by Manu Kapoor - Friday, June 19, 2015 3:26 PM -
0 Votes
How to export certain columns from a SQL table out to CSV file
Hi all I have a requirement to export data from a SQL Server 2012 table, to a CSV file.Answered | 3 Replies | 4857 Views | Created by ANSA_Naz - Monday, August 24, 2015 3:24 PM | Last reply by Milan Das - Monday, August 24, 2015 4:15 PM -
2 Votes
Copy data from one table to another
I simply need to copy the values contained in one column to another column in the SAME table so here is what I have: CREATE proc COPYDATA as Begin INSERT ...Answered | 6 Replies | 2813 Views | Created by HSSNE - Tuesday, November 20, 2012 2:21 PM | Last reply by JR1811 - Tuesday, November 20, 2012 5:03 PM -
0 Votes
Data export in csv file
you can save your Record point in another table.Answered | 6 Replies | 4633 Views | Created by YFXX - Tuesday, June 19, 2012 7:09 AM | Last reply by YFXX - Wednesday, June 20, 2012 12:57 PM -
0 Votes
Creating a Staging Table from CSV file directly
We just want to pass the input csv using which the table should be created dynamically.Answered | 7 Replies | 10977 Views | Created by MSCRMrocks - Thursday, August 30, 2012 6:12 AM | Last reply by Prasoon Pathak - Thursday, August 30, 2012 8:36 PM -
0 Votes
Copy data from one table to another
i finished by geting all the column from existing table and create new one if not exist and copy..thanks for the help friendsAnswered | 3 Replies | 7149 Views | Created by akhilrajau - Friday, July 2, 2010 6:23 AM | Last reply by akhilrajau - Monday, July 5, 2010 5:19 AM -
1 Votes
Copying data from one table into two tables
1) CREATE TABLE statements for your table(s) 2) INSERT statements with sample data.Answered | 2 Replies | 850 Views | Created by satkan17 - Wednesday, June 17, 2015 4:15 PM | Last reply by VS_SQL - Wednesday, June 17, 2015 5:04 PM -
4 Votes
PowerPivot table data copying
I have a problem when copying data manually into PowerPivot Data model.Answered | 4 Replies | 1200 Views | Created by Stevan1990 - Thursday, March 10, 2016 1:46 PM | Last reply by Ed Price - MSFT - Friday, July 29, 2016 9:10 PM -
0 Votes
Exporting data from SQL SERVER tables to a new CSV file daily
You can also use power shell for achieving this, below is the example http://msexchange.me/2013/08/03/export-to-csv-from-sql-table/Sukhija VikasAnswered | 11 Replies | 5644 Views | Created by SQL2012BI - Monday, September 10, 2012 9:27 AM | Last reply by The Tech Wizard - Sunday, March 9, 2014 4:37 AM -
0 Votes
Copying table data
What If you have data and you need it, then how do you want to truncate it?Answered | 18 Replies | 3954 Views | Created by dfolino - Thursday, June 23, 2011 7:24 PM | Last reply by Kalman Toth - Tuesday, June 28, 2011 1:33 PM -
3 Votes
Copy table including schema and data
Hi, Please take a look on the below linke ...Answered | 6 Replies | 1976 Views | Created by Zoe.Ohara - Monday, November 12, 2012 11:07 AM | Last reply by Zoe.Ohara - Monday, November 12, 2012 12:02 PM -
0 Votes
Retrieval of table data in word to .csv file
As a workaround, we can retrieve the data from the Office documents via Open XML.Answered | 1 Replies | 529 Views | Created by Devel232 - Tuesday, January 12, 2016 1:41 PM | Last reply by Fei Xue - Wednesday, January 13, 2016 5:21 AM -
0 Votes
Populate data in table from another table
Hi hemaak, I’m confused about your requirement after reading your post, could give more sample data and explain how do you get them?Answered | 2 Replies | 1209 Views | Created by emaak - Friday, November 22, 2013 10:14 PM | Last reply by Allen Li - MSFT - Monday, November 25, 2013 6:32 AM -
0 Votes
0 leading data csv
How to do the single quote or the formular = when I export zip code data as csv using the SSIS?Answered | 13 Replies | 11278 Views | Created by codebie - Sunday, January 17, 2010 8:52 PM | Last reply by codebie - Friday, January 22, 2010 9:48 PM -
0 Votes
from csv file to access 2003 table.. unicode , nonunicode conversion error
hi todd, I did choose the converted columns which come with the prefix of "Copy of", still gives me the same error.Answered | 5 Replies | 3217 Views | Created by cat_ca - Monday, August 23, 2010 4:43 PM | Last reply by cat_ca - Monday, August 23, 2010 6:09 PM -
2 Votes
Reading data from CSV
I want to know if you want to get one column of data or multiple columns of data.Answered | 34 Replies | 1702 Views | Created by anonymous_3210 - Friday, April 5, 2019 8:58 AM | Last reply by Jack J Jun - Tuesday, April 9, 2019 6:41 AM -
0 Votes
Data copying in multiple cells
Export it in CSV.Answered | 8 Replies | 1921 Views | Created by excel data - Friday, January 3, 2014 10:50 AM | Last reply by Visakh16 - Saturday, January 4, 2014 9:27 AM
No announcements
