Access Export to Excel Supress Excel Error Messages

Posted on 2012-08-26
Last Modified: 2012-09-10
Hello everyone!

I have an Access Application where I need to export Query Results to Access. The problem I'm having is that one of my fields is formatted as 'hh:nn:ss'. When I export it to Excel I get a couple of Warnings in Excel about "bad" data, but it inserts the data anyway. I then have to reformat that particular column in Excel to 'hh:nn:ss' and everything is fine.

So I guess I have a couple of questions.
1-How can I suppress the Warning in Excel?
2-Is there anyway to Export the Format 'hh:nn:ss' to Excel from Access. (I tried using the Macro option of Exporting With Format but that didn't work.

Thanks in Advance!

Question by:DwayneTharpe
    LVL 33

    Expert Comment

    How are you exporting to Excel?
    LVL 83

    Accepted Solution

    Set the DisplayAlerts to false before the export.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    This article will show you how to use shortcut menus in the Access run-time environment.
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now