Thread: Data Transfer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tod[_3_] Tod[_3_] is offline
external usenet poster
 
Posts: 17
Default Data Transfer

Depending on how you are transfering the data, it could be
that values in a field in your Excel sheet are not of the
data type established for that field in the Access table.
For example, you have a column in the sheet for dates,
that is going into the field in Access for dates. If in
the sheet column there is a value that can not be made
into a date, it will not get added to Access.

-----Original Message-----
When i import a excel sheet to a access table in is not

transfering all the data. Som rows don't get transfered
and the error is "Type" as in the type of data is bad.
.