DwayneTharpe
asked on
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
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
How are you exporting to Excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.