View Single Post
Old 06-15-2018, 03:49 AM   #10
Newly Registered User
Join Date: Jun 2016
Location: Tampa Bay Area
Posts: 49
Thanks: 21
Thanked 2 Times in 2 Posts
rgwfly is on a distinguished road
Re: Easiest way to get Excel table into Access

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.
rgwfly is offline   Reply With Quote
The Following User Says Thank You to rgwfly For This Useful Post:
CNorway (06-15-2018)