No announcements
Found 3105775 threads
-
0 VotesInsert 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 i wil ...Answered | 8 Replies | 2893 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
Inserting values from Excel sheet into Entity Framework using C#
I then perform validations and translate them into EF entities before sending them over the wire into a WCF service for commit to the database.Answered | 2 Replies | 13849 Views | Created by dotnetdeveloperjava - Friday, July 2, 2010 5:27 PM | Last reply by Joe Bako - Friday, July 2, 2010 11:59 PM -
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 | 2365 Views | Created by vickychinna - Tuesday, November 11, 2014 8:53 PM | Last reply by Patrick_Liang - Wednesday, November 12, 2014 7:48 AM -
1 Votes
Insert data in Excel database
Hi, I have excel database file.Answered | 4 Replies | 9012 Views | Created by Jimmit_05 - Tuesday, April 10, 2012 5:17 AM | Last reply by Jimmit_05 - Wednesday, April 11, 2012 8:19 AM -
2 Votes
Excel sheet to database
This is the format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyExcelFile1.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1"; Please mark the post ...Answered | 3 Replies | 2425 Views | Created by sql.anandan - Saturday, July 21, 2012 11:11 AM | Last reply by SSISJoost - Saturday, July 21, 2012 11:39 AM -
0 Votes
Excel Sheet Add-in for Access
However we can manipulate the spreadsheets in Access directly using object frame.Answered | 2 Replies | 521 Views | Created by BrianSir - Tuesday, November 17, 2015 8:42 PM | Last reply by Fei Xue - Wednesday, November 18, 2015 2:35 AM -
0 Votes
Importing Current date from an excel file into an Access Database using VBA
Just get the date/Time from Now() within your Access VBA.Answered | 4 Replies | 2224 Views | Created by ChemEng - Monday, June 3, 2013 8:29 PM | Last reply by Rich P123 - Tuesday, June 4, 2013 3:25 PM -
1 Votes
Import excel sheet to a existing access table
I'm not really familiar with Access SQL but if you wish to update existing records and insert new ones it could be something like : UPDATE ...Answered | 4 Replies | 7030 Views | Created by Faster Pussycat - Thursday, May 12, 2011 9:06 AM | Last reply by Mike Feng - Saturday, May 21, 2011 10:29 AM -
2 Votes
Uploading MS Excel Worksheet to MS Access
A Google search for: "Access 2007" import all excel in a directory Returns this amongst others: ...Answered | 2 Replies | 2125 Views | Created by Mikaila048 - Wednesday, February 29, 2012 2:53 PM | Last reply by ryguy72 - Wednesday, February 29, 2012 9:35 PM -
0 Votes
unable to connect to database server from excel sheet.
Hi Maheshwar, Connect to SQL Server 2008 R2 from Excel locally, follow the steps: Open Microsoft Excel, on the Data tab, click ...Answered | 2 Replies | 11101 Views | Created by Maheshwar Reddy - Thursday, July 5, 2012 4:42 PM | Last reply by Maggie Luo - Tuesday, July 10, 2012 8:33 AM -
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 | 17336 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
Importing the data from database to the excel sheet.
Hi Vishvvas, Sorry for the late reply, I have tested the above code, Here I have exported the code ...Answered | 6 Replies | 8518 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
Problem with ( and ) in Excel Sheet name
Hi Malhoosh1, Please try this method as below: SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0; ...Answered | 4 Replies | 5469 Views | Created by SB User - Sunday, March 11, 2012 1:54 PM | Last reply by SB User - Thursday, March 15, 2012 11:32 AM -
0 Votes
Delete sheet from the excel
The only way is by using a Script Task (or may be by using Third Party components).Answered | 3 Replies | 3030 Views | Created by SuperMan555 - Friday, March 1, 2013 6:31 PM | Last reply by SSISJoost - Monday, March 4, 2013 6:31 AM -
1 Votes
Enter Line of data into MS Access with Excel VBA
iamrick, there are several ways to enter the data in Access from Excel.Answered | 2 Replies | 2984 Views | Created by iamrick - Wednesday, February 1, 2017 2:12 PM | Last reply by iamrick - Wednesday, February 15, 2017 7:59 PM -
0 Votes
Insert new rows in existing excel sheet.
Or after you insert a new line to your Excel, add an Item or add an row to the DataGridView will be fine to resolve your questions.Answered | 4 Replies | 6423 Views | Created by ryguy72 - Tuesday, December 27, 2011 2:06 PM | Last reply by Neddy Ren - Thursday, December 29, 2011 8:28 AM -
1 Votes
Insert values into an Excel range specified by values in the resultset
Hello, The only way is to use a Script task, see ...Answered | 1 Replies | 641 Views | Created by En_J - Friday, July 15, 2016 2:25 PM | Last reply by Olaf Helper - Friday, July 15, 2016 4:43 PM -
2 Votes
Problems with "Insert into" MS Access Database
Just to clarify, my database file (JDS_Accounts.accdb) is in 3 places: 1) the original file in the directory I chose from Access when I created the Database, 2) in ...Answered | 9 Replies | 561 Views | Created by Jedasa - Wednesday, September 27, 2017 2:45 AM | Last reply by Kareninstructor - Thursday, September 28, 2017 10:15 AM -
1 Votes
Data from excel into Access
Darkviper84, Have you tried linking the Excel sheet to the Access database.Answered | 3 Replies | 675 Views | Created by Darkviper84 - Friday, August 14, 2015 8:32 PM | Last reply by DriveEV - Monday, August 17, 2015 4:04 PM -
2 Votes
Insert data to SQL server from MS Access Form
For my recuirement i need to move forward to MS Access Project not Access database.Answered | 9 Replies | 14976 Views | Created by SPKrish - Tuesday, March 13, 2012 11:07 AM | Last reply by Andrey Artemyev - Tuesday, March 13, 2012 5:36 PM - Items 1 to 20 of 3105775 Next ›
No announcements
