Forum Discussion
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.
2 Replies
If you could help us with:
1. The data file, with any PII anonymised
2. An empty database with the destination table and the code and import spec (if any) to import the data3. Your exact version number (File > Account).
Then we could do some research to confirm the issue and see if it can be fixed.
Hi,
I agree with you that there have been too many problems with Excel (and text) imports for ages. However, if this meant that the application would soon vanish, it would have done so already for about 25 years. 😉
Concerning improvements for Access, you can find out more e.g. in the Features section of our AFo blog or (a bit less up-to-date) directly from Microsoft.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
