A) I am probably doing this wrong. I am certainly doing SOMETHING wrong.
B) There is undoubtedly a faster/easier/better/more reliable (choose one or more) way
So I decided to ask the experts. I have an Access database of woodworking magazines that I am slowly populating. I thought it would be easier to just fill in the information in Excel (I'm pretty experienced with that) and then just import it into the Access table. That way I could kind of quality check the data before I put it in the database. Usually I just do one magazine at a time, save the Excel file and then import it into the Article table in the database (all are attached). Two things go wrong. First, when I import it, I always get an error message saying Access couldn't import the whole table and 0 records were not added. I don't understand that at all, because ALL the records always are added to the table. But, the other problem is that the first column in the Excel file, the magazine title (or at least an abbreviation thereof) is always blank in the Access table. I have to go back and populate it every time.
I have attached a zip file with a pared-down database and a populated Excel file. Can someone look at it and tell me how I can improve this process so I don't get error messages and do get all of the data I put in? Thanks.
View attachment DB Problem.zip
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!