[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

I have a IIS ASP reporting system running SP on SQL2000 that exports data to EXCEL and now some of the Number and Date fields displaying as text, can you please help?

Asked by RynovanRooyen in Active Server Pages (ASP)

Tags: ASP, Excel, IIS, Browser, Data type problem

Hi

We have an IIS ASP reporting system running SPs on SQL2000 that exports data to EXCEL. Now the excel reports  shows some of the Number and Date fields as text.

When we run the SPs in SQL the data is 100%, if we do a Data Import in Excel and run the SP the data is 100%.  The problems seems to be related to IIS and ASP running the SPs and exporting / generating the excel reports.

It is also changing the date format of the record from the database to excel.

Please help, thanks
Ryno
Attachments:
 
Sample-for-excel-incorrect-data-.xls (14 KB) (File Type Details) 
Sample for the incorrect data types
 
Related Solutions: ASP export to excel problem - excel is changing characters
[+][-]01/06/09 06:36 AM, ID: 23304644Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/06/09 06:42 AM, ID: 23304724Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01/06/09 06:45 AM, ID: 23304758Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/06/09 07:02 AM, ID: 23304946Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/06/09 02:13 PM, ID: 23310052Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/06/09 11:34 PM, ID: 23312611Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/07/09 01:17 AM, ID: 23313039Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_Related_20080208