Good day my Elder VBA Gurus,

I am having issues importing sheets into my access table. I have some fields set as Number Fields. And the particular column for the excel sheet is formatted as a Number type.

Yet I get the unable to append error.

If I change the data type for the field to Short Text, it imports just fine.

Any advise on what I need to do to my spreadsheet to get the data into the table as a number data type. I attached some pictures. Data Type for Table

[Excel Cell Format][2]

CodePudding user response：

Looking at the error message in one of the image you attached, it seems like you are using a primary key from a column in the excel sheet you are importing from.

During importation, choose the option to allow MS Access add primary key.

Second message from same image you attached points to data type issue, for this you can format the cells in excel to number before importing(i am giving this advise based on your comment that when you change it to shorttext it imports fine)