Error when importing data from Excel File

Hi!

This is what i'm doing:

IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=

0 AND srv.srvname = N'ExcelSource')

EXEC master.dbo.sp_dropserver @.server=N'ExcelSource', @.droplogins='droplogins';
-
EXEC master.dbo.sp_addlinkedserver
@.server = 'ExcelSource',
@.srvproduct = 'Excel',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.datasrc = @.Chemin,
@.provstr = 'Excel 8.0';

EXEC master.dbo.sp_addlinkedsrvlogin
@.rmtsrvname = 'ExcelSource',
@.useself = false,
@.locallogin = NULL,
@.rmtuser ='ADMIN',
@.rmtpassword = NULL;

set @.NomServ = 'ExcelSource';

This create a linkedServer to read my ExcelFile.

Then i'm doing this:

EXEC ('Insert into Elements (No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit)
Select No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit
from ' + @.NomServ + '...[Elements$];')

This is where i got an error. The error is:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" does not contain the table "Elements$". The table either does not exist or the current user does not have permissions on that table.

I can't figure out what i'm missing. I've add permissions for EVERYONE on the file and on the folder just to be sure and i still have the same error. How can i check if the table [Elements$] exist ?
I've forgot to mention that my excel spreadsheet name is Elements.|||I finally found what the problem was. One of my column name had the wrong Column name. Now it's working fine !

Error when generating in Excel

I am currently having a problem in production when generating a report in
Excel. I get the following error:
Reporting Services Erro
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Excel Rendering Extension : Invalid index in the index path.
----
Microsoft Reporting Services
I would certainly appreciate if any one has a solution to this issue. One
thing I have found on the web is that they talk about Office version.(i.e. we
should have Office 2003 or XP on the reporting services machine & we do have
it in production) This report was working fine in production off recent
without any problems. But now I get this error on generating a report. The
other reports are working fine in terms of generating to excel.
Any inputs is greatly appreciated.
Thanks
MukundI got to view the log files in the Reporting Services directory & found the
following details. May be it will help to find the solution to this problem.
Please let me know if anyone has a solution to this issue.
Mukund
-----aspnet_wp!chunks!998!12/22/2004-15:01:24::
i INFO: ### GetReportChunk('RenderingInfo_EXCEL', Other), chunk was not
found! this=f881b8dc-4271-49a8-aed4-4b1a9f0d1620
aspnet_wp!reportrendering!998!12/22/2004-15:01:24:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Exception: Excel Rendering Extension : Invalid index in
the index path.
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, Hashtable& riReferenceTable,
PageLayout& pageLayout, PageReportItems& pageRIItems, Stack&
dynamicLayoutStack, Hashtable& dataRegionsTable, Boolean[]& reduceRowGapList,
OutlineRenderStates[]& verticalOutlineStates, OutlineRenderStates[]&
horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(StreamWriter
streamWriter, ReportItem parentDataRegion, PageLayout pageLayout, Hashtable
formulaRIMap, Int32 currentPageNumber, PageReportItems& pageRIItems, Boolean&
isPageNeedsHeader, ExcelStyle& footerStyle, Stack& dynamicLayoutStack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
aspnet_wp!webserver!998!12/22/2004-15:01:27:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Exception: Excel Rendering Extension : Invalid index in
the index path.
aspnet_wp!library!9bc!12/22/2004-15:11:13:: i INFO: Cleaned 0 batch records,
0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
-----
"Mukund" wrote:
> I am currently having a problem in production when generating a report in
> Excel. I get the following error:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Excel Rendering Extension : Invalid index in the index path.
> ----
> Microsoft Reporting Services
> I would certainly appreciate if any one has a solution to this issue. One
> thing I have found on the web is that they talk about Office version.(i.e. we
> should have Office 2003 or XP on the reporting services machine & we do have
> it in production) This report was working fine in production off recent
> without any problems. But now I get this error on generating a report. The
> other reports are working fine in terms of generating to excel.
> Any inputs is greatly appreciated.
> Thanks
> Mukund
>|||I am aslo getting the same error. Its works for other reports. Only one report i cant export to excel and html. if any one know the solution pls reply...
From http://www.developmentnow.com/g/115_2004_12_0_0_454135/Error-when-generating-in-Excel.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Error when Exporting to Excel using SSRS 2003

Hi,

I have encountered an error when attempt to open a report which is exported to Excel using SSRS2003. It looks like this:

Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\TocsonEI\My Documents\Rigid\Reports\rptRigidTransactionSummaryReport3.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.

At first I thought it was because of the sheer bulk of the report since when I break down a month's report to every 5 days, it would export without error. So I thought that if I can break a whole report into several worksheets using page break, it might work. Unfortunately, although I did succeed in exporting the whole report into several worksheets, I still encounter the same error. Now I have no idea on what the root of the error is. Note that the same report can be exported in other formats and can be opened without error. Except for a case when I tried opening the same report exported in XML using Excel, an error which might be related to the error above occurs which says that there's an invalid unicode character in the xml file.

Any help in determining the root of the problem and a solution to it?

Hope I can help again.

It sounds like you're hitting some of the barriers of Excel 2003. I'm trying to figure out why you have 65k + rows in a spreadsheet but I probably should not ask.

Here is a kb article that references a hotfix from ms. Are you using RS 2000? Try this or grab the latest service pack.

http://support.microsoft.com/kb/905121

also see this post if you're exporting using code.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=893165&SiteID=1

cheers,

Andrew

Error when exporting to excel only

I get an error when I export my report to excel. But I do not get this error if I export the report to any other format. The error is:

An error occurred during local report processing.
An error occurred during rendering of the report.
An error occurred during rendering of the report.
Object reference not set to an instance of an object.

Any ideas what could be causing this error?

This report does contain a couple of sub-reports.

This may help you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=790946&SiteID=1

error when exporting to excel

Hi,
When I export my resport to excel in reprot manager.
It always results in an error: index is out of bounds.
How can I do that?A few questions:
Are you using SQL Server 2000 Reporting Services 2000 SP1?
What is the exact error you are receiving?
Are you using an image in a page header?
Can you reproduce the problem using a sample database? If so could you post
an RDL the demonstrates the problem?
If you cannot not reproduce the problem with sample data is it possible for
you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
of SP1
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When I export my resport to excel in reprot manager.
> It always results in an error: index is out of bounds.
> How can I do that?
>|||Thank Sir,
1. Yes, I have upgrade to SP1.
2. I am using Trandition Chinese version. The error is about index out of
bound or below zero.
3. Yes, I have two images in the page header.
4. I use Office xp. Is the problem is related to the version of Excel?
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> A few questions:
> Are you using SQL Server 2000 Reporting Services 2000 SP1?
> What is the exact error you are receiving?
> Are you using an image in a page header?
> Can you reproduce the problem using a sample database? If so could you
post
> an RDL the demonstrates the problem?
> If you cannot not reproduce the problem with sample data is it possible
for
> you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
> of SP1
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > When I export my resport to excel in reprot manager.
> > It always results in an error: index is out of bounds.
> > How can I do that?
> >
> >
>|||An "index was out of range" error will occur under the following conditions:
* SP1 is being used
* A page header contains an image
* The report is exported to excel.
The full error is "Index was out of range. Must be non-negative and less
than the size of the collection. Parameter name: index".
There are two workarounds for this issue:
* Increase the size of the page header so it is greater than the image
height.
* Set the image sizing property to "Fit"
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> Thank Sir,
> 1. Yes, I have upgrade to SP1.
> 2. I am using Trandition Chinese version. The error is about index out of
> bound or below zero.
> 3. Yes, I have two images in the page header.
> 4. I use Office xp. Is the problem is related to the version of Excel?
>
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > A few questions:
> >
> > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > What is the exact error you are receiving?
> > Are you using an image in a page header?
> > Can you reproduce the problem using a sample database? If so could you
> post
> > an RDL the demonstrates the problem?
> > If you cannot not reproduce the problem with sample data is it possible
> for
> > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
part
> > of SP1
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > When I export my resport to excel in reprot manager.
> > > It always results in an error: index is out of bounds.
> > > How can I do that?
> > >
> > >
> >
> >
>|||Thank's Sir
Your answer is excellent!
After I increased the size of the page header, it's OK
Thank a lot
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:e8oJ3PclEHA.3988@.tk2msftngp13.phx.gbl...
> An "index was out of range" error will occur under the following
conditions:
> * SP1 is being used
> * A page header contains an image
> * The report is exported to excel.
> The full error is "Index was out of range. Must be non-negative and less
> than the size of the collection. Parameter name: index".
> There are two workarounds for this issue:
> * Increase the size of the page header so it is greater than the image
> height.
> * Set the image sizing property to "Fit"
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> > Thank Sir,
> > 1. Yes, I have upgrade to SP1.
> > 2. I am using Trandition Chinese version. The error is about index out
of
> > bound or below zero.
> > 3. Yes, I have two images in the page header.
> > 4. I use Office xp. Is the problem is related to the version of Excel?
> >
> >
> >
> >
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> > :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > A few questions:
> > >
> > > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > > What is the exact error you are receiving?
> > > Are you using an image in a page header?
> > > Can you reproduce the problem using a sample database? If so could you
> > post
> > > an RDL the demonstrates the problem?
> > > If you cannot not reproduce the problem with sample data is it
possible
> > for
> > > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
> part
> > > of SP1
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > > When I export my resport to excel in reprot manager.
> > > > It always results in an error: index is out of bounds.
> > > > How can I do that?
> > > >
> > > >
> > >
> > >
> >
> >
>sql

Error when Exporting to Excel

For the last couple of weeks we've been experiencing problems when try to
export reports to Excel either from the VS IDE or the Report Manager Web.
After some tinkering and investigation (maybe more luck than judgement) we
found it to be an issue relating to Page Breaks on tables. If we unchecked
the 'Insert Page Break before this table' checkbox the report would function
correctly and export to Excel without any hassles.Hi - Any idea why the page break would cause a probem ? In my situation, it
is only a problem in a Matrix report ? it works fine for me in table reports.
"Dave Peake" wrote:
> For the last couple of weeks we've been experiencing problems when try to
> export reports to Excel either from the VS IDE or the Report Manager Web.
> After some tinkering and investigation (maybe more luck than judgement) we
> found it to be an issue relating to Page Breaks on tables. If we unchecked
> the 'Insert Page Break before this table' checkbox the report would function
> correctly and export to Excel without any hassles.

error when exporting my report to excel

hi there,
i've a question about exporting reports to excel.
when i do this , i don't get the subreports to my excel !
i only get the mainreport.
what could i do ?
thanks patrick

Well, with all due respect maybe you answered your own question "Sub_Reports".

Within your primary report do you "call or navigate" to another report - if you do, these are "Sub Reports' and they will never get exported with your primary report..
I do not know for sure - I am just rying to help and not be rude within the process... Is there more information you may be able to provide?
Best Regards,
Joe

Error viewing cube from Excel

When attempting to connect to an OLAP cube from excel. The Multidimensional Connection returns the error: "Unable to open connection. Cannot connect to the server 'myServername'. The server is either not started or too busy." Can someone please help to resolve this?

Take a look at the connection troubleshooting guide here: http://www.sqljunkies.com/WebLog/edwardm/

Another suggestion, try and repair your office installation by going through Add/Remove programs in Control panel.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.