Unable to append all the data to the table

Asked By mark davis01 0 points N/A Posted on - 01/27/2012

Hi. I need help on MS Office Access TransferSpreadsheet Macro. I need to insert common data’s in the main menu or switchboard of a database. This is to get rid of inserting data’s one by one. I tried this step but I am getting an error as posted below:

Microsoft Office Access

Microsoft Office Access was unable to append all the data to the table.

The contents of fields in 0 record(s) were deleted, and 1 record(s) were lost due to key violations.
* If data was deleted, the data you pasted or imported doesn’t match the field data types.
* If records were lost, either the records you pasted contain primary key values that already exist integrity rules For a relationship defined between tables.
Do you want to proceed anyway?

Yes no Help
 

• Status: Open
• Question Views: 3257
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By qqqqq12 0 points N/A #124443

Unable to append all the data to the table

Check this solution:

1).

-Make sure referential integrity is not being violated.

-Don't try to import a field to an autonumber.

-Make sure the data types match, ie, don't import currency into a date field.

2).

-Always use SpecificationName where possible. This stops Access from trying to determine the type of the field from the data.

-When doing a transfer manually, you can go into advanced mode, where you can load and save Import/Export Specifications.

3).

-Try to create a new table linked to the excel sheet.
-Then use an Append query to load the data.

About qqqqq12

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/08/2012
• Question Category: MS Access