No announcements
Found 3517236 threads
-
0 Votesimport data from an excel to a table
Hello, You should explore this link.Answered | 1 Replies | 4482 Views | Created by Creative_Pro - Monday, April 25, 2011 10:56 AM | Last reply by Link.fr - Monday, April 25, 2011 6:19 PM
-
2 Votes
Problem in connection to server ( SQL SERVER 2008 Express)
you need to download and install SQL Server Express from the link mention by Ahmed.Answered | 10 Replies | 3747 Views | Created by aboshanb - Saturday, July 14, 2012 4:09 PM | Last reply by Daniel_Steiner - Sunday, July 15, 2012 9:16 AM -
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 | 4136 Views | Created by dotnet.sql - Tuesday, March 6, 2012 12:51 AM | Last reply by duncandavenport - Tuesday, March 6, 2012 3:00 AM -
1 Votes
Trouble importing .dbf file into SQL server 2008 express edition
I can import my DBFs in one batch into SQL Express 2008 R2 databases.Answered | 3 Replies | 22157 Views | Created by RobChr123 - Monday, March 22, 2010 1:52 PM | Last reply by Ryan Suryanto - Saturday, January 22, 2011 6:31 PM -
0 Votes
Import data from excel file into sql server table in sql server 2008 R2 ?
Tasks - > Import Data GUI will open up in data source select excel, select path where excel file is kept...Answered | 1 Replies | 3849 Views | Created by Maggy111 - Tuesday, October 30, 2012 1:02 PM | Last reply by RahulKapoor - Tuesday, October 30, 2012 1:11 PM -
1 Votes
Importing SQL Server Express 2005 Database into SQL Server Express 2008
Backup database from SQL 2005 and restore to SQL 2008.Answered | 1 Replies | 6274 Views | Created by David2242 - Tuesday, January 11, 2011 1:08 AM | Last reply by Balmukund - Tuesday, January 11, 2011 1:14 AM -
0 Votes
Transfer data from Excel to SQL Server x64
Microsoft SQL Server 2005 Backward Compatibility Components from the SQL Server 2008 Feature Pack and use DTSRun to perform the import.Answered | 8 Replies | 5403 Views | Created by Eug723 - Wednesday, January 20, 2010 3:43 PM | Last reply by TechVsLife2 - Wednesday, January 27, 2010 5:59 AM -
1 Votes
SQL server Excel export truncation problem
http://stackoverflow.com/questions/1039385/truncation-errors-importing-to-sql-server-2005-from-excelAnswered | 7 Replies | 13288 Views | Created by Nenmeet - Wednesday, September 28, 2011 4:16 PM | Last reply by hitechiper - Tuesday, April 17, 2012 12:57 PM -
0 Votes
import data into SQL Server
Check this link it will help in giving you ideas on how to import data from Excel to SQL 1- to import ...Answered | 1 Replies | 3278 Views | Created by rbbenson - Monday, January 2, 2012 9:24 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, January 3, 2012 3:15 AM -
1 Votes
Importing from Excel to SQL Server 2005
are you using ssis for this, OR simply sql statement to import the excel files?Answered | 3 Replies | 4146 Views | Created by aspwebapps - Monday, July 9, 2012 9:21 AM | Last reply by Vikash Kumar Singh - Monday, July 9, 2012 12:08 PM -
1 Votes
how to import excel file to SQL Server 2008 via stored procedure?
Create a linked server with Microsoft.Jet.OLEDB.4.0 provider to your Excel/Access file on your SQL Server Express instance, and then create a linked ...Answered | 9 Replies | 15928 Views | Created by RedRose2009 - Thursday, April 22, 2010 1:11 PM | Last reply by Samsudhin - Friday, February 14, 2014 4:00 AM -
3 Votes
Importing Data from Access To SQL
Please mark the replies that helped you to "Import Data from Access To SQL" as an answer.Answered | 19 Replies | 14021 Views | Created by ba7ranya - Tuesday, July 27, 2010 7:04 AM | Last reply by Afohlag - Tuesday, November 9, 2010 5:55 PM -
0 Votes
Having trouble importing Excel 2007 to SQL Server 2005
And the "Preview Data" succeeds and shows you the contents of the Users worksheet, after you select "Users$" as the table to import from?Answered | 5 Replies | 5028 Views | Created by tarcenea - Monday, October 12, 2009 7:45 PM | Last reply by Douglas Laudenschlager (V) - Tuesday, October 27, 2009 4:52 PM -
0 Votes
Importing Excel into SQL 2008
However, when I preview it in BIDS, the data shows the IDNUMBER for JOHNSON, JAMES as NULL.Answered | 2 Replies | 5069 Views | Created by MattTheZergling - Wednesday, January 12, 2011 9:08 PM | Last reply by Nik - Shahriar Nikkhah - Wednesday, January 12, 2011 9:28 PM -
2 Votes
SQL Server 2008 R2 Express 64bit Linked Server
Windows Server 2008 R2 Standard 64bit.Answered | 4 Replies | 7935 Views | Created by Alphonse G - Wednesday, October 6, 2010 8:29 PM | Last reply by Charles Wang - MSFT - Thursday, October 14, 2010 2:48 AM -
0 Votes
Excel 2007 Export to SQL Server 2008
Hi Mel, Here are two samples for your reference: Import Data from Excel to ...Answered | 5 Replies | 6922 Views | Created by Mel3 - Friday, June 17, 2011 8:22 PM | Last reply by Calvin_Gao - Monday, June 27, 2011 8:43 AM -
0 Votes
Importing Excel 2003 file to SQL server 2008
what modification have you done on the excel file.Answered | 3 Replies | 9522 Views | Created by shasam - Monday, April 4, 2011 7:03 PM | Last reply by Peja Tao - Wednesday, April 6, 2011 5:20 AM -
0 Votes
SQL Import Data From Excel sheet
Hello, Seems there is a check constraint on one or more columns in the SQL Server table and the ...Answered | 2 Replies | 1979 Views | Created by ahmed mohamed labib - Thursday, October 1, 2015 2:19 PM | Last reply by ahmed mohamed labib - Saturday, October 3, 2015 3:00 PM -
2 Votes
Import data from excel file to sql server in c# windows application
You can take all the data from the excel and put it in a datatable.Answered | 16 Replies | 40956 Views | Created by ashwebza - Tuesday, February 21, 2012 10:10 AM | Last reply by Buzz Harald - Tuesday, July 3, 2012 7:47 AM -
1 Votes
Dynamic connection with Excel 2007 in SQL Server 2008
Hi NoviceBee, Based on my understanding, if you'd like to reflect the changes in SQL Server, you don't need to import the ...Answered | 1 Replies | 981 Views | Created by NoviceBee - Wednesday, September 9, 2015 10:53 AM | Last reply by Eric__Zhang - Thursday, September 10, 2015 6:43 AM
No announcements
