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.

Beginner Asked on January 13, 2021 in How To's.
Add Comment
2 Answer(s)

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.

 

Rookie Answered on January 13, 2021.

Thanks Steveklett

on January 13, 2021.
Add Comment

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.

 

Beginner Answered on January 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor