Forum Discussion

Daryl West's avatar
Daryl West
Copper Contributor
Sep 17, 2025

Access Still Struggles on Data Import

More of a comment than anything else

 

I have been a frequent flyer of Access since version 2.0. We used it almost daily for several years. I have since retired, and was away from it for a couple years now. However, due to a recent Office 365 account I started using again. One of the problems we had over the years with Access was on large data imports. This appears to be the same problem today as it was 30 years ago. Excel does not have this problem. Some of the same issues with Access "Does not recognize header name" Checking to insure header name was not a keyword and all rules were enforced, still did not allow the data to be imported. Since I needed to quickly turn around the information I had to link to an Excel file and run the queries. 

Pondering if MS has really done any improvments or serious upgrades with Access. I know programs cost resources to update. The other 3 Office apps have far more users than Access. I think Access is going to wither away within the next couple years. Was a great run when everything worked right. I have used a lot of different databases over the years. However, Access was the runt who was very user friendly and an awesome reports generator. 

 

No RepliesBe the first to reply

Resources