Search results

Oh lovely! Thanks for the help - I appreciate it.

It works - but I don't understand why a reader in a different Access forum (not this one) suggested "linking" to the excel spreadsheet rather than just importing the data (no append queries needed). I followed these steps below and I was able to get the data into the table I needed with far less...

I may have figured it out! I thought I had created a record in the table above the table I was trying to import data into but I had not. Silly me! I needed that initial data in order to know the correct autonumber so the imported data would relate to the tables above it. Once I created that...

Thanks for the suggestion! I'm dropping the worksheet into the table section of the navigation pane and it isn't working. Was I dropping in the wrong spot?. I also tried linking to the data and then creating an append query (first time I've done that). I get to the point in the append query...

I'm not that awesome at Access and this way worked for me. I'm always open to any other suggestions. I had another person suggest linking to the excel table and running an append query to pull the data in. I've currently linked the data but I'm trying to learn how to run an append query right...

Thanks for the link. I was really excited about it at first because it directly addressed the error message I was dealing with, but sadly none of the suggestions to fix the problem worked. Not being able to use paste append may render my database useless, as I need to be able to import...

I have a table where I need to be able to paste data from Excel into the table in Access. I'm usually pasting about 100-300 records when I do this. I've used paste append successfully for years in Access 2003 for years. Now that I've upgraded to 2007 it no longer works and I get this error...