Importing Excel to Access Table

[Import Excel to Access shows Null Fields]

When I import a column from Excel that has values 0001 and 1111, the 0001
appears in Access fields as 0001, but the 1111 appears as null. How can I get
Access to recognize both? I've switched from changing the type to text and
number, but neither works.

 

[Ken Snell \(MVP\)]

Most likely the field value of 1111 in EXCEL is still a "number" format,
even though you've changed the column to be Text. In EXCEL, the previous
numeric format for a cell will "stick" to the value until you do one of the
following:

Double-click into that EXCEL cell, then click on any other cell -- that will
'update' the cell to the Text format.

Or, add a ' character to the front of the 1111 value in the cell to tell
EXCEL that the value is Text.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Import Excel to Access shows Null Fields" <Import Excel to Access shows
Null (e-mail address removed)> wrote in message
news:[email protected]...

 

[a a r o n . k e m p f]

it looks to me like you're trying to use Binary data.

I would try this same thing in SQL Server and see if you have the
problem.
In general-- Jet doesn't really support the Binary datatype