I have defined the ODBC settings and tested these ok along with the selection citeria of Date / DepotID / ContractID
How do i call / execute the SP to make a local table of the results whilst also apply the selection criteria?
An example of one of my attempts is below;
Expand|Select|Wrap|Line Numbers
- DoCmd.Execute "SELECT SPNAME.* INTO " _
- & "[LocalTableName] WHERE DeliveryDate = 'datDeliveryDate' & DepotID = 'DepotID' & ContractID = 'ContractID'"
Thanks inadvance