View Single Post
Old 06-15-2018, 05:15 AM   #11
Newly Registered User
Join Date: Feb 2018
Posts: 26
Thanks: 22
Thanked 0 Times in 0 Posts
CNorway is on a distinguished road
Re: Easiest way to get Excel table into Access

Originally Posted by rgwfly View Post
I usually export the SAP data into a text file and then link to the database. I found sometimes the excel export from SAP caused errors. Then you can just overwrite the same file when you do future exports. There may be better ways doing it out there.
In SAP I use variants and defined layouts to ensure the data is consistent.
Thanks. I haven't tried text files. So, I will give it a try and see if that simplifies the process. Thanks.
CNorway is offline   Reply With Quote