Got too excited a moment ago and posted without context.
THANK YOU to all who helped!!!! So much appreciated. I had to move the semi colon at the end of the statement and we are good to go!!! Here is the final strSQL concatenation
Code:
strSQL = "INSERT INTO tblTemp SELECT * FROM (SELECT Replace(f4,'.d','') AS LabID, F6 AS [Level], f7 AS [Date], F8 AS PFBS, F11 AS [Symmetry PFBS], F14 AS [13C6-PFHxA], F20 AS PFHxA, F23 AS [Symmetry PFHxS], F26 AS [13C3-HFPO-DA], F32 AS [HFPO-DA], F38 AS PFHpA, F44 AS PFHxS, F50 AS ADONA, F56 AS PFOA, F62 AS PFNA, F68 AS PFOS, F74 AS [9Cl-PF3ONS], F80 AS [13C9-PFDA], F86 AS PFDA, F92 AS NMeFOSAA, F98 AS PFUnA, F104 AS [d5-NEtFOSAA], F110 AS NEtFOSAA, F116 AS [11Cl-PF3OUdS], F122 AS PFDoA, F128 AS PFTrDA, F134 AS PFTA FROM [TEXT;DATABASE=F:\PFAS Exported Data\;HDR=No]." & Forms!frmImport537Data!txtSequence & ".csv WHERE F4 Not Like 'Blank*' And F4<>'Data File') AS txt;"
Then used Baldy's code to execute from within the build event of the text box in the form.
Code:
CurrentDb.Execute strSQL, dbFailOnError
Slick as can be!!!!!!
Thanks again to all.