Cancel that.
Figured it out by just entering the text value into the Select line-
INSERT tblASXhistoricals (arcTime,StockID,TradeTime,OpenPrice,HST_Close,Bid,Ask,LastTrade,Volume)
SELECT 'mmm',tblStockPrice.StockID,TradeTime,OpenPrice,HST_Close,Bid,Ask,LastTrade,Volume
FROM tblStockPrice INNER JOIN tblStock ON tblStock.StockID = tblStockPrice.StockID
WHERE tblStock.RIC LIKE '%.AX'
Thanks anyway