S
sebastico
Jerry Many thanks for your kindness.
My database is:
TFarmer {Farmer (PK Number), FarmerName, FarmerCountry}
TFarmerData {CodData (PK, Autonumber), CodFarmer (FK, Number), County, Year,
Semester, Date}
TFarm {CodFarmer (PK (Autonumber), CodData (FK, Number) }
TLandUse {CodLand (AutoNumber), CodFarm (Number) CodLandUse (Lookup table
with Number Field), Quantity (Number)}
TFarmer 1:∞ TFarmerData
TFarmerData 1:∞ TFarm
TFarm 1:∞ TLandUSe
The related database is TFarmer TFarmerData TFarm
TLandUSe
The objective is monitor farms twice a year during 2 years.
The tables above (first semester) are in Excel format and I want to export
to Access. Next semester I can be able to enter data into de Access Database
without exporting data
When I try to get external Excel data (with or without Autonumber key) from
Access this message is displayed: “Microsoft Office was unable to append all
the data to the tableâ€
“*If data was deleted, the data you pasted or imported doesn’t match the
field data types or the FieldSize property in the destination table.
*If records were lost, either the records you pasted contain primary key
values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.â€
As you can see I need to get external data from TLandUSe (Autonumber PK) to
Access as well.
I have checking books, papers and in the Web, and I was unable to find any
reference to import tables with Autonumber Key. All examples in books and
paper describe the Library Database the exclude importing Autonumber PK Excel
tables to MS Access.
Again thank you very much indeed
My database is:
TFarmer {Farmer (PK Number), FarmerName, FarmerCountry}
TFarmerData {CodData (PK, Autonumber), CodFarmer (FK, Number), County, Year,
Semester, Date}
TFarm {CodFarmer (PK (Autonumber), CodData (FK, Number) }
TLandUse {CodLand (AutoNumber), CodFarm (Number) CodLandUse (Lookup table
with Number Field), Quantity (Number)}
TFarmer 1:∞ TFarmerData
TFarmerData 1:∞ TFarm
TFarm 1:∞ TLandUSe
The related database is TFarmer TFarmerData TFarm
TLandUSe
The objective is monitor farms twice a year during 2 years.
The tables above (first semester) are in Excel format and I want to export
to Access. Next semester I can be able to enter data into de Access Database
without exporting data
When I try to get external Excel data (with or without Autonumber key) from
Access this message is displayed: “Microsoft Office was unable to append all
the data to the tableâ€
“*If data was deleted, the data you pasted or imported doesn’t match the
field data types or the FieldSize property in the destination table.
*If records were lost, either the records you pasted contain primary key
values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.â€
As you can see I need to get external data from TLandUSe (Autonumber PK) to
Access as well.
I have checking books, papers and in the Web, and I was unable to find any
reference to import tables with Autonumber Key. All examples in books and
paper describe the Library Database the exclude importing Autonumber PK Excel
tables to MS Access.
Again thank you very much indeed