CODEWITHSUNDEEP
excelamosvba
user9180469
user9180469

Reputation: 1

How to push data from excel spreadsheet to any application

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.

Upvotes: -2

Views: 635

Answers (1)

ashleedawg
ashleedawg

Reputation: 21619

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.

Upvotes: 0

Related Questions