Last post Mar 13, 2009 03:49 PM by surpandu1983
Mar 13, 2009 03:49 PM|surpandu1983|LINK
There are two issues I am facing in my code
The scenario is
From C# code I am opening excel 2007 workbook as database.
In the workbook there are certain named ranges defined with scope as both
workbook and sheets.
e.g. EventLiveDate (workbook level) valInEvent (sheet level)
When I am trying to query them as
1. select * from EventLiveDate
2. select * from ['Store2DG_1'valInEvent]
I am getting result from first but second gives and exception
"The Microsoft Office Access database engine could not find the object
''Store2DG_1'valInEvent'. Make sure the object exists and that you spell its
name and the path name correctly."
But when i use workbok in excel 2003 this works fine.
Small size excel 2003 workbook is giving no problem but when size of the
workbook is 130 MB, it gives runtime error system resource exceeded.
This is a bit urgent .....