Does anyone know if there's a method to export a query into an excel spreadsheet?
I've looked around, but I can't seem to find any solution that works.
I'm just getting the data like so:
SQL Code:
SELECT tbl_HPMRBInventory.ID, tbl_HPMRBInventory.RecvDate, tbl_HPMRBInventory.CSO_N, tbl_Commodity.CommodityType, tbl_HPOEMPN.Part_Number, tbl_HPOEMPN.Platform, tbl_HPMRBInventory.Site_ID, tbl_HPMRBInventory.GP_TransferError, tbl_HPOEMPN.OEM_Name FROM ((tbl_HPMRBInventory LEFT JOIN tbl_HPOEMPN ON tbl_HPMRBInventory.PN_ID = tbl_HPOEMPN.ID) LEFT JOIN tbl_Commodity ON tbl_HPOEMPN.Commodity_Type = tbl_Commodity.ID) LEFT JOIN tbl_Location ON tbl_HPOEMPN.LocationID = tbl_Location.LocationID WHERE (((tbl_HPMRBInventory.GP_TransferError) Like 'Invalid Part in GP*') AND ((tbl_HPMRBInventory.GP_Transfer)=0 Or (tbl_HPMRBInventory.GP_Transfer) Is Null)) ORDER BY tbl_HPMRBInventory.RecvDate;
So I was hoping I could do the same, but automatically export it all to a spreadsheet.




Reply With Quote