Solved

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

  • 11 May 2023
  • 1 reply
  • 156 views
O
Rank
Userlevel 3
Badge

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.

icon

Best answer by Robert Sternberg 11 May 2023, 07:07

View original

1 reply

Robert Sternberg
Rank
Userlevel 7
Badge +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/

Robert Sternberg, Crestwood Associates -- ** Summit 2024 - Visit Us at Booth #600 ** -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved