Hi,
I am trying to create some additional records in an existing Access table by copying (Ctrl C) the data from the excel rows and pasting into the table using paste append.
All that is happening is Access is creating the additional auto number rows, but the data I want copied over does not appear? The data to be copied is just regulars numbers, no weird formatting etc….
I have also created another table and added the data I want copied across and tried to use an append query, but I am getting some strange results. I am sure it’s something basic I am doing wrong with the query, but It all seems quite complicated for such a simple task, am I missing something?
Thanks
I am trying to create some additional records in an existing Access table by copying (Ctrl C) the data from the excel rows and pasting into the table using paste append.
All that is happening is Access is creating the additional auto number rows, but the data I want copied over does not appear? The data to be copied is just regulars numbers, no weird formatting etc….
I have also created another table and added the data I want copied across and tried to use an append query, but I am getting some strange results. I am sure it’s something basic I am doing wrong with the query, but It all seems quite complicated for such a simple task, am I missing something?
Thanks