.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Migrate/Upgrade from Office 2003 (Excel, Access...etc) to Office 2010

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint


We are about to begin a project to upgrade our MS-Office suite from 2003 to Office 2010.  This will include the migration of a large number of excelwork books with macros and access database and forms,   Is there an established (or tried and true) process for conducting the analysis work to determine if the excelwork books require individual attention (evaluation, conversion and testing) or can be converted in bulk?

Are there any know issues?  

Our company have a strong support relation with microsoft, Does any one know the perfect person who did similar kind of work or can help to do this?

Thanks, Vijay


View Complete Post

More Related Resource Links

SharePoint 2010 with EXCEL Service- Support for Office 2003


Hi All,


I have an query. I am using EXCEL Service on SharePoint 2010. Some of users in my network has Office 2003 installed on there Laptop. I have a template which is designed in Office 2010 and uploaded to Document library,

My questions is:

1) Will users who have office 2003 or Office 2007 be able to use that template and fill in data?







In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Office 2010 will not open Office 2003 Documents on SharePoint

Going directly to a document in the document view and selecting any of them will present the Read Only/Edit prompt and when clicking Read Only Word or Excel 2010 depending on the document type will open to a blank page and just sit there. If you do a search and then click on the documents that are returned in the search results, it opens as expected.

Sharepoint 2010 integration with Office 2010, 2007,2003

hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator

SharPoint 2010 : Open word and excel documents within Browser without installing office Web App on S

guys, SharePoint 2010 how can i have the word documents and excel sheets open up with in the browse windows without installing Office Web App on the server, all i want to give users is the read access. Also i did not install anyting on sharepoint server to have pdf open up in the browser and yet it does. thanks in advance. sameer   thanks sameer

Excel speardsheet can't be open for sharepoint 2010 Office Web App

I had no problem opening word and power point, but excel. it will giving me this error Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 06ebb5b3-d79a-4304-9709-11b4a6f55c57 Date and Time: 9/16/2010 6:08:19 PM I am pretty much done all the solution I can found on-line. anyone know how to fix this issue or it is the Bug that sharepoint 2010 have right now ?

Sharepoint 2003 with Office 2010


We work with Sharepoint 2003. I've put a Excel 2003 file online.

On a PC with Office 2010:

  When opening this file for viewing it shows the file, ok.

  When opening the file to edit with Excel it starts Excel (2010), but shows an empty sheet.

Any idea what's wrong here?

Microsoft Office Excel cannot access the file.There are several possible reasons: . The file name or

Hi all,
I am workin on Arc IMS web application project where I will be uploading an excel file containing data say city,addresszip(column headers in excel file)..etc..and load necessary column data in listboxes..and finally save the data to an excel file..when I run though Studio I dont get error..when I run through browser..I got errors ..I even modified DCOMCNFG...But..I get the below error..
Microsoft Office Excel cannot access the file 'E:\vijay\ArcIms\Excelsheets'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.
Here goes my code..
Imports Excel
Imports System.Data.OleDb
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim connection As New System.Data.OleDb.OleDbConnection
    Dim command As New System.Data.OleDb.OleDbCommand
    Dim dr As System.Data.OleDb.OleDbDataReader
    Dim cmd1 As New System.Data.Ol

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.


Hello everybody.

I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error :

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'. There are several possible reasons:

. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.

At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website?

In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required.

Please help. I am in great trouble. Thanks in advance.

Sharepoint 2010 Issues with IE and Office 2003

I'm having an issue where Sharepoint 2010 is only working with alternative browsers when using Office 2003. We have Office 2003 installed on most of our systems and it seems like the only way to get around this on IE is to install Office 2010. Is there a way to use 2003 and IE?

Microsoft Office Excel cannot access the file


Hi All,

I'm having difficulty opening microsoft office files  in this case Excel on a Sharepoint 2007 site when using IE 6.  Here are the errors I get: 

Excel:  Microsoft Office Excel cannot access the file
'https://<var>server_name</var> SPSsite/documents/<var>file_name</var> .xls'. There are several possible reasons:
The file name or path does not exist.
The file being used by another program.
The workbook you are trying to save has the same name as a currently open workbook.

Here are some additional details:

OS = Vista
IE = Version 6

Please help me :)


Problem using Office 2010 64 bit driver for MS Access


I've a 64 bit SSRS 2008 R2 server. My goal is to provide user the capability to create a report against Access 2003. In order to do that I am installed  Office 2010 64 bit driver for MS Access from the following site: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d. The driver got installed just fine, when I try a UDL, I do see the option: Microsoft Office 12.0 Access Database Engine OLE DB Provider. But when I try to create a Data Source in SSRS, I do not see that provider under OLEDB. Can anyone suggest what I should do? 



vb 2010 64 bit Office 2010 Access


I have an application in vb2010 Professional that reads and writes to Access and Excel. It works with Office 2010 32 bit but I have a client who creates huge spreadsheets and would like Office 64 bit.

I think in vb2010 I can target a 64 bit machine. How do I communicate with Access 2010?. My current code is:

            con1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = C:\VB\Test VB RWC.accdb "

            StrSql2 = "SELECT * from materials order by materials.name"

            db = New OleDb.OleDbDataAdapter(StrSql2, con1)
            db.Fill(ds1, "MDataSet")

            'txtName.Text = ds1.Tables("MDataSet").Rows(0).Item(1)
            Me.DGV1.DataSource = ds1

etc. etc

I assume once I fill the dataset I manipulate it the same as office 2007.

         I am an engineer programmer s

Microsoft Office Excel cannot open or save any more documents because there is not enough available


hi all,

     i am new to asp.net programming i am trying to create an ms excel file with charts drawn in it,

i wrote the complete code for it but the it is saying

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 

i have set the permissions to my complete disk space and all user accounts, and i tried with anti-virus disabling also it didnt work please try to help me out and my code is :

Imports System.Data.OleDb
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Tools.Excel
Imports System

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Smart Tags: Realize the Potential of Office 2003 by Creating Smart Tags in Managed Code


While you may well be excited about the prospect of building managed smart tags, there is little information available to help you create them using .NET. In this article the author fills in the blanks. Along the way he discusses the Microsoft Office Smart Tag List XML schema, advanced managed smart tags for Office 2003 and Office XP, and deploying these features in an organization.

Ben Waldron

MSDN Magazine February 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend