• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Access Export to Excel Supress Excel Error Messages

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!

Dwayne
0
DwayneTharpe
Asked:
DwayneTharpe
1 Solution
 
NorieCommented:
How are you exporting to Excel?
0
 
CodeCruiserCommented:
Set the DisplayAlerts to false before the export.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now