Excel has the "Command Type" listed as SQL.
From what I've researched, the "Command Text" looks like SQL to me:
SELECT
`Sheet1$`.Export as "Date", `Sheet1$`.F2 as "Invoice #", `Sheet1$`.F3 as "Location", `Sheet1$`.F5 as "Phone", `Sheet1$`.F7 as "Phone #", `Sheet1$`.F8 as "Term", `Sheet1$`.F9 as "Rate Plan", `Sheet1$`.F11 as "Employee"FROM `C:Data Dump FilesRQ-Activation Report-Sales Tracker.xls`.`Sheet1$` `Sheet1$`ORDER BY `Sheet1$`.Export DESC
I am trying to save the file from my POS software without having to open it and tamper with it. I have my Store Managers performing these tasks, so I'm trying to make it as "user friendly" as possible. "Work arounds" just open the door for mistakes.