No announcements
Found 3255561 threads
-
3 VotesColumn names created when importing a spreadsheet instead of the spreadsheet's header row
Making sure all columns had a header name in the first row helped :-)Pål AAnswered | 4 Replies | 16736 Views | Created by TessaH - Monday, August 31, 2009 10:07 AM | Last reply by manish parab - Friday, October 18, 2013 2:43 PM
-
4 Votes
Choosing which column is the title when importing a spreadsheet
Hi , i know the thread must have expired but wanted to share this information I found the best solution - What happens is when we ...Answered | 8 Replies | 22119 Views | Created by RobertMann - Friday, December 17, 2010 2:59 PM | Last reply by Sushant78 - Monday, July 2, 2012 5:05 AM -
0 Votes
Unexpected error when importing into MOSS from a spreadsheet
Since the rest of the columns were not created, the rows could not be inserted.Answered | 3 Replies | 8492 Views | Created by JimBoeri - Thursday, September 18, 2008 11:43 PM | Last reply by SharepointRani - Thursday, July 12, 2012 9:31 PM -
43 Votes
"The search key was not found in any record" importing spreadsheet to table
I had this same issue and was a little confused (newbie) when I read this post since my column headings in the original import/table had spaces throughout and I had no ...Answered | 31 Replies | 127535 Views | Created by AllTheGoodNamesWereTaken - Saturday, June 8, 2013 3:51 AM | Last reply by BRobb1 - Monday, October 15, 2018 12:32 PM -
0 Votes
Converting Spreadsheet to dB when many cells on each row are ref labels
col3 = RSado(2) RSdao.Update RSado.MoveNext ...Answered | 5 Replies | 910 Views | Created by Mel_3 - Wednesday, May 29, 2013 2:59 PM | Last reply by Rich P123 - Wednesday, May 29, 2013 8:34 PM -
4 Votes
Import spreadsheet error
I have had no problems creating an SP list by importing a spreadsheet when using an ID that is part of the domain that the SP server belongs to.Answered | 31 Replies | 50762 Views | Created by raq - Friday, April 27, 2007 2:45 PM | Last reply by Mike Walsh FIN - Sunday, September 18, 2011 4:03 PM -
0 Votes
import denormalised spreadsheet
---- I am trying to import a denormalised spreadsheet into a normalised data base.Answered | 2 Replies | 3090 Views | Created by __pc__ - Wednesday, May 12, 2010 3:36 AM | Last reply by Nik - Shahriar Nikkhah - Wednesday, May 12, 2010 1:36 PM -
1 Votes
An unexpected error has occurred when importing Excel Spreadsheet
Then click Import Spreadsheet.Answered | 7 Replies | 31017 Views | Created by Sheri Tingle - Sunday, May 29, 2011 1:54 PM | Last reply by Máté Benyovszky - Saturday, January 26, 2013 11:24 PM -
2 Votes
Is It Possible To Use SQL Server To Add A Header Row To Existing Excel Spreadsheets?
Have you seen this as a way to add headers to the bcp output?Answered | 2 Replies | 554 Views | Created by Anthony C-UK - Thursday, June 4, 2015 3:15 PM | Last reply by Ed-Elliott - Friday, June 5, 2015 8:19 AM -
0 Votes
Import all of multi-sheet Excel spreadsheet into List?
By default, when we import data from an excel file into a SharePoint, we just can import data from a spreadsheet, not multi-sheets.Answered | 1 Replies | 2410 Views | Created by scogordo - Tuesday, April 21, 2015 5:52 PM | Last reply by Wendy DZ - Wednesday, April 22, 2015 6:24 AM -
0 Votes
Cannot Import Spreadsheet
Initially SP showed there was going to be a problem because the field where you enter the spreadsheet file name displayed in gray but the error didn't happen until ...Answered | 5 Replies | 7592 Views | Created by DOCMAN - Wednesday, December 9, 2009 2:06 PM | Last reply by cmgtbone - Wednesday, January 27, 2010 4:50 PM -
0 Votes
Import an Excel Spreadsheet
Hi, Try below links ...Answered | 4 Replies | 1619 Views | Created by Jon Jarrett - Thursday, December 26, 2013 7:22 PM | Last reply by SathyanarrayananS - Friday, December 27, 2013 2:38 AM -
0 Votes
Import All Spreadsheets in Directory To SQL Server
If the Excel files are mixed e.g. .xls, .xlsx then multiple connection strings need to be setup where you can add the file name in along with indicating in first ...Answered | 3 Replies | 460 Views | Created by RonPaulWearsRedSocks - Tuesday, September 6, 2016 3:40 PM | Last reply by Paul P Clement IV - Wednesday, September 7, 2016 12:37 PM -
1 Votes
Creat Excel spreadsheet with WPF
You can also create a .csv file and just rename to .xls and Excel will handle that just fine if you're not concerned about formatting.Answered | 2 Replies | 12432 Views | Created by DioNNiS - Thursday, June 17, 2010 8:59 PM | Last reply by Matt Searles - Tuesday, June 22, 2010 3:35 AM -
5 Votes
import a single spreadsheet into several SQL Server tables
In real world you do not need to drop them, instead of Table1, Table2, Table3 you have to use your real tables and column.Answered | 6 Replies | 8650 Views | Created by ttim - Friday, April 8, 2011 2:45 PM | Last reply by Arbi Baghdanian - Wednesday, April 13, 2011 4:09 PM -
13 Votes
How to import Excel spreadsheet into SharePoint 2013 list?
When done, the import will create the columns and data.Answered | 31 Replies | 208746 Views | Created by JMGreg - Friday, March 22, 2013 6:03 PM | Last reply by BChristian - Friday, February 16, 2018 12:12 AM -
2 Votes
Look up a row in an Excel Spreadsheet the Edit the contents of the other columns in the row.
You'll need a form with some text boxes whose controlsource is dynamically set to the columns for the row with the matching surname.Answered | 3 Replies | 3752 Views | Created by lerlh - Tuesday, May 3, 2011 9:21 AM | Last reply by lerlh - Tuesday, May 3, 2011 8:34 PM -
0 Votes
Error Importing Spreadsheet with Excel Import App
https://social.technet.microsoft.com/Forums/office/en-US/65d6f5cc-8e15-4ae0-93f6-17279ba31a50/unable-to-import-excel-file-into-sharepoint-foundation-2013-using-import-spreadsheet ...Answered | 2 Replies | 1823 Views | Created by SteveWeberInKingsPark - Friday, December 4, 2015 8:33 PM | Last reply by KRISHANA KUMAR - Monday, December 14, 2015 2:25 PM -
0 Votes
how to import excel spreadsheet with boolean and hyperlink columns to sharepoint 2013 list
Hi Amit, I understand you want to insert boolean and hyperlink column via importing spreadsheet from excel to SharePoint list.Answered | 2 Replies | 7782 Views | Created by Amit Lohogaonkar sharepointer - Thursday, May 7, 2015 8:07 PM | Last reply by Amit Lohogaonkar sharepointer - Saturday, May 9, 2015 10:36 AM -
0 Votes
Newbie trying to create PowerShell to delete rows in an Excel spreadsheet
The last used row in any spreadsheet is always: <sheet>..UsedRange.Rows.Count No, the ...Answered | 9 Replies | 1966 Views | Created by Thirst For SQL - Monday, May 23, 2016 6:30 PM | Last reply by jrv - Friday, May 27, 2016 8:34 PM - Items 1 to 20 of 3255561 Next ›
No announcements
