append not adding all records (1 Viewer)

M

Monoplankton

New member

Local time

Today, 13:35

Joined

Jan 31, 2017

Messages

3

• May 15, 2018

• #1

hi hopefully someone has had this issue before. I have an import from an excl file that im trying to append to the main table. Everything was working fine until now. In the example i've uploaded 4 of the 5 records won't append, any ideas? I've gone blind to this and can't see any problems please help.

 

Attachments

• example.accdb

  1,008 KB · Views: 38
• import.xls

  24 KB · Views: 60

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 13:35

Joined

Jul 9, 2003

Messages

16,280

• May 15, 2018

• #2

This can happen if there are different data types. You might have Excel data that looks like a number, but is actually text.



Sent from my SM-G925F using Tapatalk

 

M

Monoplankton

New member

Local time

Today, 13:35

Joined

Jan 31, 2017

Messages

3

• May 15, 2018

• #3

HI Uncle Gizmo. The data from the excel file imports into the import table without any issues but when it appends to the Sheet0 file only one record appends. All the data fields match and microsoft gives no error!!!

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 20:35

Joined

May 7, 2009

Messages

19,237

• May 15, 2018

• #4

Therr is nothing wrong, it does append the records.

 

M

Monoplankton

New member

Local time

Today, 13:35

Joined

Jan 31, 2017

Messages

3

• May 15, 2018

• #5

Sorry guys your right Ive been looking at a different date field.

Thanks for putting me straight.