View Single Post
Old 06-15-2018, 05:15 AM   #11
CNorway
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

Quote:
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