Exporting data from Print Menu

[computerlady143]

I am trying to export my inventory Items. I went to the Item Listing reports and tried several others. I even went to customer listing report and everything will only print to .text (ASCII format)- I know the options depends on the report. What reports will export to a file and lets me choose Excel or something different that ASCII? I basically want to export all my customer listing, vendors, Inventory items, etc. I don't have VI. I just need to get the data to Excel at least .csv.

 

[BigLouie]

Open Excel
Go to External Data
New Database Query
Select the SOTAMAS90 DSN
Enter in your log in information.
Select IM1
TaDa! There is your Inventory file in Excel.