Hello,
I working on a report in which I have to fetch data from Excel sheet and use it in a Crystal Reports XI. Everything is working great except one problem. If the cell is type DATE in Excel sheet then crystal report is not able to recognize it and gives me blank. Not sure how to fetch Date from Excel sheet. Can someone please help me.
Example:
1. I Connect to desired Excel sheet through Acces/Excel (DAO) connection type in Crystal Reports.
2. In the Add command box I wrote following script
select 'sample'.'F1' as Name,
'sample'.'F2' as Address,
'sample'.'F3' as Birthdate
from 'Sheet1$' 'sample'
When I run it, it excute without any error, but when the data is fetched, the Birthdate column is null bcaz it is of type DATE.
Please help.
I working on a report in which I have to fetch data from Excel sheet and use it in a Crystal Reports XI. Everything is working great except one problem. If the cell is type DATE in Excel sheet then crystal report is not able to recognize it and gives me blank. Not sure how to fetch Date from Excel sheet. Can someone please help me.
Example:
1. I Connect to desired Excel sheet through Acces/Excel (DAO) connection type in Crystal Reports.
2. In the Add command box I wrote following script
select 'sample'.'F1' as Name,
'sample'.'F2' as Address,
'sample'.'F3' as Birthdate
from 'Sheet1$' 'sample'
When I run it, it excute without any error, but when the data is fetched, the Birthdate column is null bcaz it is of type DATE.
Please help.