Is there any way to integrate MS Access with Netsuite?
We have attendance management system in MS Access. Now we wants to pull data from access to our custom records.
If you’re stuck with Access you’ll need a process that can run on the machine hosting access and push data to NetSuite via RESTlet or web services. If you can sync your access data to a web-accessible SQL server (MS SQL, MySQL, etc.) then you can use something like Celigo Integrator IO to push the data to NetSuite. If you can tolerate some degree of manual processing, you can export your Access data to CSV and then perform CSV imports into NetSuite, or once again use a Data Loader with Celigo Integrator IO if you need a rich toolset to handle mapping and transformation.
Thanks Steveklett
May be worth looking at/speaking to CData
https://www.cdata.com/drivers/netsuite/
I’ve only ever looked at their products from the perspective of getting data out of Netsuite into MS applications, but seem to recall the Excel tool could update live Netsuite data, so they may be able to do similar with Access.
