Skip to main content
Solved

How to load data from an excel sheet into a table of acumatica ?

  • 11 May 2023
  • 1 reply
  • 285 views

Forum|alt.badge.img

Hi,

I need to create a new custom table in acumatica and load data taken from an excel file into the newly created table. Can someone provide me the work around to accomplish this?

Thank you.

Best answer by Robert Sternberg

Hi @oshadarodrigo64 please reference these two articles.  They describe the process. 
 

Importing Historical Data into Acumatica – With a Cool Twist by Tim Rodman

https://www.augforums.com/importing-historical-data-acumatica-cool-twist/

 

Technical Tuesday: Building Reports from a SQL View by Doug Johnson 

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

View original
Did this topic help you find an answer to your question?

1 reply

Robert Sternberg
Captain II
Forum|alt.badge.img+8

Hi @oshadarodrigo64 please reference these two articles.  They describe the process. 
 

Importing Historical Data into Acumatica – With a Cool Twist by Tim Rodman

https://www.augforums.com/importing-historical-data-acumatica-cool-twist/

 

Technical Tuesday: Building Reports from a SQL View by Doug Johnson 

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings