Recent content by damcdon

Thank you very much It works perfect with a few tweaks, the "why" is, im trying to return one bit of information from the query to run a command based on that bit of information. Here is what I ended up using Dim s() As String Dim l As Long s = Split(ver1, vbCrLf)...

Thank you for responding, The data type in field1 is text and the result of ver1 is below but I think its trying to insert all of that into one field and what I need is one collum and multiple rows, similar to what a .txt import does. Also the error message im getting reads Run-time error...

Hi All In reference to the following thread : http://www.access-programmers.co.uk/forums/archive/index.php/t-91354.html I have managed to stumble through the "Recordset method" and am now able to insert a string into a table :-), the only problem I have is there is too much data so I assume...