Re: Accessing Excel data - Some columns are not coming through
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 07 Apr 2006 11:32:34 -0400
Even though I'm sure your file is virus-free, you're not going to find
anyone brave enough to download it in this day and age. Also, the
folks who answer questions on the newsgroups do not have the time to
do extensive troubleshooting on entire applications--they usually have
other jobs for which they get paid. I'd recommend googling some of the
specific error messages you receive, or asking in the Excel
newsgroups, or hiring a paid consultant if you can't find the answer
online.
--Mary
On Wed, 5 Apr 2006 14:13:02 -0700, Pradeep Tapadiya
<PradeepTapadiya@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,.
Can someone please help us out?
Thank you in advance.
Pradeep
"Pradeep Tapadiya" wrote:
Netters,
We use ADO.NET OleDb Data Connector extensively to read data from any Excel
file. It has worked great for us so far, that is, until we came across a
particular Excel file that does not bring data for some columns. I am
wondering if anyone can any idea on why this would happen.
You can download the problem Excel file from
http://www.examinfusion.com/download/ExcelProblem.zip
Don't worry. There are no viruses:-).
The zip file also contains the sample code to demonstrate this problem. This
is a simple ADO.NET code to create a connection and execute the query.
Nothing special.
As you will see from the output, row 259 and 260 must show some data for
columns "Box" and "EA6." However, they are not coming through.
Thank you in advance for your help.
Pradeep
- Prev by Date: Re: VFPOLEDB: works with DB on my machine but not with network server
- Next by Date: Re: Microsoft OLE DB Provider for SQL Server in MS Access
- Previous by thread: Re: OleDBDataAdapter.Fill() causing memory corruption
- Next by thread: Re: Accessing Excel data - Some columns are not coming through
- Index(es):
Relevant Pages
|
Loading
