Print Page | Close Window

OLE DB connection to Excel Missing Columns

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20919
Printed Date: 19 Apr 2025 at 12:57pm


Topic: OLE DB connection to Excel Missing Columns
Posted By: thummel1
Subject: OLE DB connection to Excel Missing Columns
Date Posted: 28 Jul 2014 at 8:59am
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, 


-------------
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson


Print Page | Close Window