Originally Posted by rgwfly
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.