Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


reading Excel file in asp

Posted on 2004-11-29
Medium Priority
Last Modified: 2008-01-09
Has anyone had experience reading from an excel file into asp? If so I need to discuss how to implement it.
Question by:longjt
  • 3
  • 2
LVL 46

Accepted Solution

fritz_the_blank earned 400 total points
ID: 12697166

Author Comment

ID: 12697662
OK I can get the Microsoft example to run, very sloppy code on Microsoft’s behalf. Anyway when I try to run the same code against another file I get:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Excel Driver] External table is not in the expected format.

I have updated my system DSN and added the named range to the new table. What is the expected format?
LVL 46

Expert Comment

ID: 12697699
I am not sure--no way to tell without being there. Is the excel file in the same directory as your page? If not, then you may have a permissions error.

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.


Author Comment

ID: 12697722
Yes the file is in the same dir as the asp page. so was the test page. im going to look at the file itself to see if i can find any problems with format.

Expert Comment

ID: 12701902

Is the file csv or xls?  If it's csv, you can read it as a flat file and format it in a table as you read each line.  If it's xls, then FtB's link is what you need.

The error message you received sounds to me like the tables you're calling are different than how you're calling them.  Could you paste your code so we can analyze?


LVL 46

Expert Comment

ID: 12996728
The answer in ID: 12697166 works--longjt  said so in ID: 12697662.


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question