Search results

  1. T

    Import multiple rows of text into one field

    Got it so far ... I had to add DAO to the begining of the Recordset DIM statement as this: Dim rst As DAO.Recordset Now, If I can I would like to do 2 things. 1. fix it from erroring out when it reaches the last record. 2. put in a space when it hits the word NOTE Thanks for all the help.
  2. T

    Import multiple rows of text into one field

    Fixed a few errors but ... I have worked through a few errors but that last one has me stumped. I used the exact code above with a few modifications till I get it to at least run. Here is my exact code. Function TestMe() Dim MyLine As String Dim MyID As String Dim MyNote As String Dim rst...
  3. T

    Import multiple rows of text into one field

    Humm..keep getting error 13 type mismatch on this line Set rst = CurrentDb.OpenRecordset("MyTable", dbOpenDynaset) I am using Access 2000, ADO 2.9, Jet 4 I made the references to DAO3.6 objects in the VB Editor. How are you calling the function if you don't mind me asking? I made a module...
  4. T

    Import multiple rows of text into one field

    Here is a sample That is the basic structure. I have attached a sample of the data and the index file. Thanks for the quick reply.
  5. T

    Import multiple rows of text into one field

    Greetings, I have searched and searched for the best way to do this and I am stumped so here goes. I will try to be as detailed as I can with my explaination. I have a text file with data I want to import into access. here is what it looks like. 00100378435 NOTE: 01/13/05 07:27 Cat...
Back
Top Bottom