External Data Dropping Cells with Alphanumeric Data

[breynolds0431]

Hello. I'm working with a workbook that connects to an external data source (table in excel) when opened. Most of the data from the external table consists of 6 numerical digits. However, some cells have alphanumeric cells which is the 6 digits followed by a single letter. The data connection brings in all non-alphanumeric cells, but drops the alphanumeric ones altogether. I've tried changing the alphanumeric cells on the external table to "Text" only, but it still doesn't pick up on the workbook? Any ideas why that might happen or how to resolve so the workbook brings in all data?

 

[Jerry Sullivan]

This thread regarding mixed data types and its links may help.
http://www.mrexcel.com/forum/excel-questions/742347-problem-sql-adodb-connection.html

 

[breynolds0431]

That did it. Thank you!