What are you trying to do exactly? Do you have a file sitting on a directory somewhere with relevant data that you would like to import into your Palo database? And the file may, or may not, be in the correct format so you need to do some formatting of it before loading?
Or are you doing some data entry that needs to be loaded similar to the attached file?
Or is there another scenario? All of these should be accomplished easily with the vba and Palo tools available.
I'm trying using VBA for Data Import and I got this strange problem.
I called the Macro "AutoRun" and added in the end Close.Application.
In this way when I open the Excel file everything works fine, but if I open this excel file with the command line in a .bat file consolidation does not works.