No announcements
Found 3642033 threads
-
5 VotesImporting data from excel to SQL Server
Because import excel data into SQL Server would be way easier than using SSIS.Answered | 7 Replies | 2331 Views | Created by cloudsInSky - Thursday, October 10, 2013 4:14 PM | Last reply by SathyanarrayananS - Friday, October 11, 2013 4:05 PM
-
0 Votes
Import Data from Excel to SQL Server 2005
Read this for common Unicode problem in ...Answered | 1 Replies | 5413 Views | Created by aspwebapps - Friday, May 25, 2012 11:46 AM | Last reply by Onur Omer Ozturk - Friday, May 25, 2012 12:09 PM -
0 Votes
how to Import Excel Sheet data in SQL server
You can find the Providers under the Linked Servers tab in SSMS, or by using master.dbo.xp_enum_oledb_providersduncan davenport . data engineer and ...Answered | 3 Replies | 4139 Views | Created by dotnet.sql - Tuesday, March 6, 2012 12:51 AM | Last reply by duncandavenport - Tuesday, March 6, 2012 3:00 AM -
0 Votes
Export data from sql server to excel without excel sheet constraint
Hi Rocket, How many rows will be exported?Answered | 4 Replies | 3330 Views | Created by SekharT - Thursday, March 6, 2014 5:16 PM | Last reply by Mike Yin - Thursday, March 13, 2014 2:04 PM -
0 Votes
Import data from sql server 2005 to excel
Probably could use a few more details regarding the export, but the below code demonstrates one method you can use: Dim ExcelConnection As New ...Answered | 2 Replies | 2119 Views | Created by WITWEW - Wednesday, September 21, 2011 2:47 PM | Last reply by Paul P Clement IV - Wednesday, September 21, 2011 4:03 PM -
0 Votes
Pulling Excel Data into SQL Server
http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Excel%20Data%20Export%20to%20SQL%20Serve ...Answered | 6 Replies | 1206 Views | Created by ChapWolff - Tuesday, December 15, 2015 12:03 AM | Last reply by ryguy72 - Tuesday, December 22, 2015 5:27 AM -
0 Votes
importing data to excel from sql
Get Data From Other Sources > From Microsoft Query Create a new Data Source using wizard or use existing one I created a ...Answered | 5 Replies | 1379 Views | Created by palermo_software - Tuesday, May 17, 2016 8:17 PM | Last reply by eralper - Monday, May 23, 2016 11:16 AM -
0 Votes
Sql Server Import Export Wizard Export Excel 2003 Error
Using the Import/Export Wizard to export values from a table to an Excel 2003 file.Answered | 6 Replies | 5065 Views | Created by Donna Lee - Monday, September 26, 2011 9:44 PM | Last reply by Debu Basu - Thursday, September 29, 2011 1:26 PM -
0 Votes
Importing Data into Sql Server 2012 from Excel Data
Make sure table fields have sufficient length to accept values coming from Excel source.Answered | 2 Replies | 2095 Views | Created by Sivakumar Keelamanda - Wednesday, March 12, 2014 3:02 PM | Last reply by Visakh16 - Wednesday, March 12, 2014 3:36 PM -
0 Votes
Export data from SQL server to Excel
And how do you Export the data?Answered | 4 Replies | 1085 Views | Created by Shaik Mastanvali - Thursday, November 3, 2016 1:52 PM | Last reply by Lin Leng - Friday, November 4, 2016 6:48 AM -
0 Votes
error while exporting data from sql server to excel
http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Excel%20Data%20Export%20to%20SQL%20Serve ...Answered | 5 Replies | 3795 Views | Created by Umesh98 - Saturday, July 26, 2014 4:00 PM | Last reply by ryguy72 - Saturday, August 2, 2014 11:19 PM -
3 Votes
How to export data from sql server to excel file through queries?
Hi Pranil, Do you want to export the records from SQL Server using T-SQL and SELECT statements?Answered | 6 Replies | 18363 Views | Created by Pranil Yambal - Monday, June 28, 2010 4:48 AM | Last reply by Pranil Yambal - Friday, July 23, 2010 9:37 AM -
0 Votes
Export from SQL to Excel
Hi Bradwhatever, So far Azure SQL Sever can't export data to excel,csv,txt as the on-premises SQL ...Answered | 2 Replies | 1492 Views | Created by Bradwhatever - Monday, February 16, 2015 10:33 PM | Last reply by Eric__Zhang - Tuesday, February 17, 2015 2:11 PM -
0 Votes
Issue to export data from sql to excel
Just try to edit mappings from wizard or from BIDS, in the end you just have to correct datatypes and it should work then.Answered | 9 Replies | 1325 Views | Created by Guoxiong Yuan - Friday, January 30, 2015 9:29 PM | Last reply by Guoxiong Yuan - Tuesday, February 3, 2015 5:13 PM -
1 Votes
Import excel data in sql 2013
Hello, You can also configure an Excel workbook as a linked server in SQL Server and then query data by using OPENQUERY.Answered | 5 Replies | 2614 Views | Created by pet06 - Friday, April 18, 2014 7:38 PM | Last reply by Fanny Liu - Monday, April 21, 2014 1:28 PM -
2 Votes
Excel to SQL Server
If the destination tables already exist in SQL Server then you can use the SQLBulkCopy ...Answered | 2 Replies | 2939 Views | Created by amit_kumar - Thursday, June 23, 2011 10:39 AM | Last reply by Paul P Clement IV - Thursday, June 23, 2011 12:08 PM -
2 Votes
Import Excel into SQL Server
Open context menu (right mouse click) and select Tasks/Import Data.Answered | 4 Replies | 15784 Views | Created by Adam Quark - Wednesday, January 25, 2012 8:02 PM | Last reply by ryguy72 - Tuesday, January 31, 2012 1:39 PM -
1 Votes
SQL Server R2 Export data to Excel (XLSX)
Been quite a few years now and exporting to a pretty much redundant version of Excel (2003) is becoming more and more of an issue.Answered | 4 Replies | 6624 Views | Created by -VB- - Thursday, July 22, 2010 5:16 AM | Last reply by JCEH - Thursday, October 24, 2013 10:46 AM -
0 Votes
Transfer data from Excel to SQL Server x64
Another roundabout way would be to export the Excel data into a CSV file and import it using BCP.Answered | 8 Replies | 5406 Views | Created by Eug723 - Wednesday, January 20, 2010 3:43 PM | Last reply by TechVsLife2 - Wednesday, January 27, 2010 5:59 AM -
0 Votes
copying data from Excel to SQL Server
Here is an example: INSERT INTO MyTable(column1, column2, column3) SELECT column1, column2, column3 FROM ...Answered | 2 Replies | 4587 Views | Created by kumarkv - Tuesday, April 6, 2010 6:07 AM | Last reply by BGPMK - Tuesday, April 6, 2010 9:46 AM - Items 1 to 20 of 3642033 Next ›
No announcements
