No announcements
Found 2923430 threads
-
0 Votescopying data from Excel to SQL Server
Here is an example: INSERT INTO MyTable(column1, column2, column3) SELECT column1, column2, column3 FROM ...Answered | 2 Replies | 4591 Views | Created by kumarkv - Tuesday, April 6, 2010 6:07 AM | Last reply by BGPMK - Tuesday, April 6, 2010 9:46 AM
-
0 Votes
Copying data from one excel to another excels
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\IP.xls;Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";Hope this helps !!Answered | 4 Replies | 4466 Views | Created by Pavan Marri - Tuesday, March 2, 2010 4:38 PM | Last reply by Sudeep Raj - Wednesday, March 3, 2010 9:04 AM -
3 Votes
Copying data from Excel to Sharepoint 2013 list
I did and now I can copy data with carriage return.Answered | 4 Replies | 1854 Views | Created by John.P.Smith - Tuesday, August 26, 2014 10:36 AM | Last reply by John.P.Smith - Thursday, August 28, 2014 9:13 AM -
1 Votes
Read data from excel and copy into another excel file
Code Reference Fouad RoumiehAnswered | 3 Replies | 1554 Views | Created by missy786 - Wednesday, June 3, 2015 10:40 AM | Last reply by Fouad Roumieh - Thursday, June 4, 2015 8:14 AM -
2 Votes
Missing rows when copying data from results grid to excel
Task > Export data.Answered | 5 Replies | 13080 Views | Created by Dormen - Friday, March 17, 2017 7:58 AM | Last reply by uberb1oke - Wednesday, December 12, 2018 11:59 AM -
0 Votes
Copy data from Excel or MS project to SQL Azure
Hi, Once you are connected to sql azure from MACRO you can run the sql command in the same way as you are running them against on premise database.Answered | 6 Replies | 2633 Views | Created by Anonymous10023 - Thursday, March 19, 2015 8:16 PM | Last reply by Mukesh(MSFT) - Thursday, March 26, 2015 7:05 AM -
11 Votes
Copy datas from Excel/Access to Table (using VS2015u3)
And I assume you already figured out how to import database form Access/excel file to SQL Server database.Answered | 12 Replies | 1814 Views | Created by Duvernet Vincent - Tuesday, October 18, 2016 12:08 PM | Last reply by Duvernet Vincent - Tuesday, November 1, 2016 11:18 AM -
0 Votes
Error when copying large amount of data from Access Database To SqlServer
Anyway try this, export data from Access to Excel, simple dataflow Excel to SQL and in a couple of minute you resolved your issue.Answered | 5 Replies | 1119 Views | Created by Ripon1 - Friday, May 16, 2014 8:30 PM | Last reply by Ripon1 - Monday, May 19, 2014 4:42 PM -
0 Votes
Copying all data from a DataSet to a SqlCompact database
Hi, If you want to import a dataset to the SQL Server database including the schema, you could use SMO (the SQL Server Management Objects) to read your DataSet's ...Answered | 2 Replies | 5480 Views | Created by InterX - Monday, April 12, 2010 7:33 AM | Last reply by Xiao-Min Tan – MSFT - Wednesday, April 14, 2010 8:35 AM -
2 Votes
Copy data from excel spreadsheet and paste to table
Give OPENROWSET a look in books online; judging from your past posts over the past couple of days, you really do need to get a good boock and try working some of the excercises.Answered | 2 Replies | 6314 Views | Created by a__21 - Thursday, August 2, 2007 9:23 PM | Last reply by VidhyaSagar - Friday, August 3, 2007 2:05 AM -
0 Votes
Error Copying Excel Data
Bessie Zhao [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark ...Answered | 3 Replies | 5109 Views | Created by obrienkev - Monday, December 20, 2010 5:14 PM | Last reply by Bessie Zhao - Tuesday, December 28, 2010 9:42 AM -
1 Votes
Importing the data from database to the excel sheet.
Create a package you can easily query the data from database and convert to excel.Answered | 6 Replies | 8591 Views | Created by bharat999 - Monday, May 23, 2011 4:05 AM | Last reply by Paul Zhou - Friday, May 27, 2011 4:58 AM -
0 Votes
Easy copy of a database with data
All it did was destroy my database.Answered | 4 Replies | 1545 Views | Created by ShoppingCart - Friday, May 10, 2013 3:42 AM | Last reply by ShoppingCart - Friday, May 10, 2013 3:31 PM -
1 Votes
Insert data in Excel database
Hi, I have excel database file.Answered | 4 Replies | 9107 Views | Created by Jimmit_05 - Tuesday, April 10, 2012 5:17 AM | Last reply by Jimmit_05 - Wednesday, April 11, 2012 8:19 AM -
0 Votes
Alternatives to SSIS to copy data to an excel file
From where are you copying the data?Answered | 1 Replies | 1511 Views | Created by Sreedhar Lakam - Friday, September 13, 2013 2:08 PM | Last reply by ArthurZ - Friday, September 13, 2013 3:03 PM -
1 Votes
Copy database structure but not the data
Hi, I tried using same GENERATING the script to export the database schema but was unsuccessful as some of the procedures were ...Answered | 6 Replies | 63808 Views | Created by Judith Weader - Wednesday, February 13, 2008 3:40 PM | Last reply by Peter8444 - Wednesday, April 1, 2015 1:39 AM -
0 Votes
Extract Data From Excel To Database Table
Check these two tutorials on how to do it: How to import Excel files with different names and same schema into database?Answered | 2 Replies | 2685 Views | Created by runnerpaul - Thursday, November 15, 2012 3:09 PM | Last reply by Joon84 - Friday, November 16, 2012 12:34 PM -
0 Votes
copy data from datatable to database table
this link is really helpful.Answered | 1 Replies | 2734 Views | Created by sqldeveloper2008 - Friday, July 13, 2012 8:03 AM | Last reply by RohitArora - Friday, July 13, 2012 8:17 AM -
0 Votes
Copy data Excel (point to comma)
Hi, I have a program where the user can select an input file (Excel) which contains data.Answered | 1 Replies | 518 Views | Created by YannickB90 - Friday, April 15, 2016 6:03 AM | Last reply by Ashidacchi - Friday, April 15, 2016 6:21 AM -
0 Votes
unable to copy the sql data in excel multiple rows
So you have a table that contains some text and you want to copy the text to Excel sheet.I would use Ssis package and try edit the excel sheet to multiple text allowance.Answered | 2 Replies | 1396 Views | Created by excel data - Friday, January 3, 2014 7:16 AM | Last reply by Uri Dimant - Friday, January 3, 2014 9:10 AM - Items 1 to 20 of 2923430 Next ›
No announcements
