Hi, I'm Using Crystal Reports 2008. I created an OLE DB connection to an xlsx file (Excel 2007). When I did that, some columns did not come over at all. These columns have very little data in them, but still, there is data in there. They are just "missing" when I look at "Sheet_1" in the Field Explorer. My questions are:
1. Why would specific columns of data in an Excel spreadsheet not be recognized in creating an OLE DB link?
2. What's the best way to remedy? I thought about adding "test" data to the first row in every column, formatted the way I need (string, numeric, date...)
Any suggestions would be great,
IP Logged