I’ve been asked to bring in some historical/static data from a legacy system for a new Acumatica customer. Going to be using it for reference only via GIs I figure if needed. Some of it is quite detailed, many fields, etc. I was going to create and load new Acumatica tables to hold the data and then I realized to use the import scenarios I need a screen name. For my purposes, I don’t' need a screen necessarily. Is there anyway in Acumatica to load data directly into a table from a file, the files at the moment are given to me as tab delimited text files, without having a screen in Acumatica? I’m not a SQL expert, but I’m presuming the tables could be loaded directly via SQL commands, but wondering if I’m missing something..
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.