ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Transfer (https://www.excelbanter.com/excel-programming/290553-data-transfer.html)

tim

Data Transfer
 
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.

Tod[_3_]

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.
.



All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com