I need to push some 3000 entries from excel to an application called AMOS so could it be possible by excel vba or through some other utilities or applications.
Asked
Active
Viewed 508 times
-2
-
2That would depend on the capability of AMOS. Better to ask them – chris neilsen Jan 06 '18 at 07:38
-
To push data from Excel spreadsheet to any application is possible using any programming which is able handling Excel and the goal application as well. – Axel Richter Jan 06 '18 at 07:59
1 Answers
0
AMOS doesn't support Excel data being programmatically "pushed in to it".
Instead, save the Excel data as file type CSV (Comma delimited) and then import into AMOS. You can create a CSV file programmatically if necessary.
AMOS can also import Excel 97-2003 XLS files, but not XLSX. You can save a newer file as XLS in Excel by choosing file type Excel 97-2003 Workbook (*.xls).
More info here.
ashleedawg
- 20,365
- 9
- 72
- 105