PDA

View Full Version : How to access the literal content of a cell, regardless datatype



deyken
01-19-2012, 11:50 PM
Hi All,

I am trying to access a column in Excel, where the content has been literally typed as "'04505", with the leading ' to make numbers with leading zeros show those zeros.

I am uploading this column's data into a database, but when it has been uploaded, the data in the DB Table truncated the leading zero. How can I access the contents of an Excel worksheet Cell "as-is"?

I tried formatting these cells as "Text", but it did not work. The leading zeros are still being truncated.

Aflatoon
01-20-2012, 01:44 AM
What field type is the database field? I would suspect numeric.