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!