No announcements
Found 2959596 threads
-
1 VotesError on Trying to insert into SQLServer table while reading data from excel
Hi I am trying to use "insert into table" in SQL Server.Answered | 1 Replies | 751 Views | Created by vbguy2019 - Sunday, August 4, 2019 4:18 PM | Last reply by Peter Fleischer - Sunday, August 4, 2019 7:00 PM
-
3 Votes
reading excel tables in c#
Since you are using VSTO Add-In and I am not sure how you are inserting the data in the excel file (There are so many ways), here is a VBA code which you can convert to ...Answered | 9 Replies | 6593 Views | Created by ramesh-ch - Monday, April 9, 2012 3:01 PM | Last reply by Dummy yoyo - Friday, April 20, 2012 3:14 AM -
1 Votes
Insert data in Excel database
Hi, I have excel database file.Answered | 4 Replies | 9100 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
Read from Multiple excel sheet & insert in to list
Hi, According to your description, you might want to extract values from Excel files and insert into SharePoint List.Answered | 2 Replies | 2428 Views | Created by vickychinna - Tuesday, November 11, 2014 8:53 PM | Last reply by Patrick_Liang - Wednesday, November 12, 2014 7:48 AM -
0 Votes
bulk inserting from excel
the code I posted first inserts all of the data from the Excel spreadsheet into a table called TempExcelImport.Answered | 10 Replies | 5342 Views | Created by OM_12 - Wednesday, December 17, 2008 11:55 AM | Last reply by Adam Haines - Monday, January 5, 2009 8:18 PM -
6 Votes
Inserting Specific columns to SQL Table from Excel Sheet
If you don't want to import the data like suggested by others, you can just copy the data from Excel to SSMS.Answered | 3 Replies | 17510 Views | Created by Mr Paul Johnson - Wednesday, December 19, 2012 12:37 PM | Last reply by Steen Schlüter Persson - DK - Thursday, December 20, 2012 10:12 AM -
1 Votes
insert in a table from Excel file if excel records are not there in the table
hello, i have a table called employee_info in a database that I have to update from excel files, so that if none of the employee's field was ...Answered | 1 Replies | 2387 Views | Created by Butmah - Tuesday, February 7, 2012 9:56 AM | Last reply by Koen Verbeeck - Tuesday, February 7, 2012 10:28 AM -
1 Votes
Unable to insert records into a Database table.
The Database is correct.Answered | 6 Replies | 1101 Views | Created by r_a_ven - Tuesday, September 2, 2014 2:44 AM | Last reply by r_a_ven - Tuesday, September 2, 2014 9:03 PM -
0 Votes
Insert Data to table from excel file
no, what i would like to do is to import the entire spredsheet into a specific tableAnswered | 10 Replies | 6832 Views | Created by EladRez - Monday, October 11, 2010 5:15 AM | Last reply by EladRez - Tuesday, October 12, 2010 3:24 PM -
79 Votes
Reading Excel From C#
i m able to retrieve table names from the excel sheet but the sheet array returns 2 entries for each excel table. and ...Answered | 78 Replies | 1072476 Views | Created by NewtoCsharp2008 - Tuesday, October 11, 2005 10:49 PM | Last reply by Thari777 - Monday, May 28, 2012 10:59 AM -
0 Votes
read data from excel
Create an OLE DB Connection Manager that connects to the corresponding server database.Answered | 5 Replies | 1346 Views | Created by chelseasadhu - Tuesday, January 27, 2015 5:11 PM | Last reply by Visakh16 - Wednesday, January 28, 2015 9:32 AM -
0 Votes
how to upload data from Excel to Database table
I m not askin for creating new excel file what i am asking is different and the link u have given is different this i have done.Answered | 4 Replies | 2665 Views | Created by Ajay Singh Rawat - Wednesday, April 18, 2012 5:59 AM | Last reply by Koen Verbeeck - Wednesday, April 18, 2012 6:38 AM -
0 Votes
Using Excel VBA to Insert into SQL Server 2008 R2 Table
Read this http://support.microsoft.com/kb/321686.Answered | 1 Replies | 5080 Views | Created by rafcmptrxprt - Friday, March 28, 2014 12:38 PM | Last reply by Vithor da Silva e Silva - Friday, March 28, 2014 1:26 PM -
0 Votes
Mapping an Excel spreadsheet to a Database Table
You can automate the whole process by executing the procedure/ SSIS package through a SQL job The Excel can be uploaded to a FTP/SFTP location set ...Answered | 1 Replies | 1410 Views | Created by etl2016 - Sunday, November 19, 2017 10:12 PM | Last reply by Visakh16 - Monday, November 20, 2017 5:18 AM -
0 Votes
Insert selected column from multiple excel sheet ????
Dear Sir, I have idea of loading al the diffrent excel shee in diffrent table using foreach loop will explain or post me steps or any link where ...Answered | 8 Replies | 2955 Views | Created by Vipin jha - Thursday, July 5, 2012 8:48 AM | Last reply by Vipin jha - Friday, July 6, 2012 5:17 AM -
0 Votes
Incremental primary key insert from excel to db
Insert data from excel to the Temp table.Answered | 9 Replies | 1102 Views | Created by K_W1 - Monday, July 6, 2015 12:23 PM | Last reply by Sethu Madhavan R - Tuesday, July 7, 2015 2:00 PM -
0 Votes
Inserting data from a table in database 1 to an identical table in database 2...both databases are on the same server
Since both table are identical, you might not need to specify the 'Identity' column while you are inserting into the Second table.Answered | 6 Replies | 2019 Views | Created by ChemEng - Friday, January 18, 2013 9:51 PM | Last reply by Naarasimha - Friday, January 18, 2013 10:35 PM -
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 | 2675 Views | Created by runnerpaul - Thursday, November 15, 2012 3:09 PM | Last reply by Joon84 - Friday, November 16, 2012 12:34 PM -
0 Votes
Cannot SELECT from table during INSERT transaction
AdaTheDev makes an excellent additional point with some lateral thinking!Answered | 5 Replies | 12414 Views | Created by kikin111 - Monday, December 20, 2010 8:38 PM | Last reply by John Sansom - Tuesday, December 21, 2010 11:09 AM -
1 Votes
Combining Excel spreadsheets with database tables.
----INSERT INTO TestTable using SELECT INSERT INTO TestTable (FirstName, LastName) SELECT ...Answered | 2 Replies | 1871 Views | Created by midolphins90 - Wednesday, May 14, 2014 5:10 PM | Last reply by Visakh16 - Wednesday, May 14, 2014 6:02 PM - Items 1 to 20 of 2959596 Next ›
No announcements
