kentwoodjean
Technical User
I checked several other threads and FAQ, having tried a few things, but they just don't fit my situation.
I have a telephone file that I download from Crystal Reports to Excel where I run a macro to clean up the file. I then import into an Access table. The duration of each call is tracked in hours, minutes and seconds. For instance, 00:00:00. When I move this data from Excel to Access (currently cut and paste) it formats 00:00:00 as long as the data type is Text. Because I want to to perform an average calculation on a report, I tried to change the data type to a number or continue using Text, using an imput mask of hh:nn:ss. No matter what I do, the import to Access from Excel will not occur unless the data format is a Text file without imput mask. If I imput as Text, then my report will not allow me to do the average calculation. Am I missing something?
I have a telephone file that I download from Crystal Reports to Excel where I run a macro to clean up the file. I then import into an Access table. The duration of each call is tracked in hours, minutes and seconds. For instance, 00:00:00. When I move this data from Excel to Access (currently cut and paste) it formats 00:00:00 as long as the data type is Text. Because I want to to perform an average calculation on a report, I tried to change the data type to a number or continue using Text, using an imput mask of hh:nn:ss. No matter what I do, the import to Access from Excel will not occur unless the data format is a Text file without imput mask. If I imput as Text, then my report will not allow me to do the average calculation. Am I missing something?