Hi,
How do I copy/paste data from my Excel spreadsheet into Access? When I copy a range of cells from Excel then paste it into Access, the pasted data is shifted by 1 column to the left so that my first column (dates) from Excel is not imported and all my newly pasted data is under the wrong heading. Do I need to add an extra first column to my excel spreadsheet as an "ID" column?
Historically I've just been using the import function on Access but it seems to take a long time so I'm just trying this method.
Thanks,
Jason
Bookmarks