Excel Report using Data Connection issue with MS SQL Timestamp

Posted on 2012-09-12
Last Modified: 2012-09-25

I have a Excel 2007 report using Data Connections to MS SQL views. The report came out perfect except for 2 [TIMESTAMP] fields are just not appearing in the report.

I tried for other SQL tables and the same thing happened. How can I get the Excel to show these columns?

Below pic shows I can see the 2 columns in MS SQL.
View can be seen in MS SQL select statement
Question by:NicksonKoh
    LVL 16

    Accepted Solution

    try this code instead:

    select top 100 No,
    cast(Time_Stamp_Src as bigint) as 'Time_Stamp_Src',
    cast(Time_Stamp_Tgt as bigint) as 'Time_Stamp_Tgt',
    from mutu.spm.v_erp_prod_item_c

    Open in new window

    you'll just get numbers, because that's what they are - sequential numbers.  Conversion to nchars or nvarchars is forbidden, which is what's happening as the system sends them to Excel.


    LVL 17

    Author Closing Comment

    Thx. I adopted your idea!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now