Sounds like Jet is determining the data type of your column
incorrectly.

The data types in the existing MS Access table are irrelivant if the
table is being overwritten. Instead, Jet tries to determines the data
type from the new data at the time of import. If it dtermines the data
type too hastily, any subsequent values which are of a different data
type will fail and be imported as blanks.

Check the following registry settings for the machine:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows

Setting the value to 0 (zero) will force Jet to scan all column values
before choosing the appropriate data type.

--

Tim wrote in message ...
I have a sheet made in excel which has the exact same format as a table in access. when i import the excel table to access and overwrite the access table some of the rows do not transfer over and become blanks in the access table.
Any suggestions?