Search results

  1. D

    Create Table Using Split Command

    Brilliant, thank you. That's working like a charm :D
  2. D

    Create Table Using Split Command

    Thank you, that's working to create the table, and when I run it as database 34 I get 164 (Did you run it twice?) records with no issues :) However, when I copy that code to my database it runs and uncovers the next problem; unfortunately, in the full dataset, some of the first serial numbers...
  3. D

    Create Table Using Split Command

    I tried the options in #23 & #24 & get a single "Error 28 (Out of Stack Space) in SplitToRows procedure" followed by many "Error 13 (Type mismatch) in SplitToRows procedure" errors using either
  4. D

    Create Table Using Split Command

    I get "Compile error: Syntax error" at the new code "If IsNull(rsSource!Serial Then GoTo Skip_To_Next"
  5. D

    Create Table Using Split Command

    OK, I've reassigned the field names and got rid of Error 3265. I now have new problems which is "invalid use of null" and "Error 13 type mismatch". These are presumably bought about because some of my records don't have a value in 'Serial' How can I adapt the code so that it ignores records...
  6. D

    Create Table Using Split Command

    Thank you, I've tried the above code but am still getting Error 3265 - Item not found in this collection, The field I'm trying to split is named "Serial" so I have removed _source_ from line 80. I have also tried using [Serial] and I've tried renaming the field on the database & in the code...
  7. D

    Create Table Using Split Command

    Line 80 is where it's erroring. I get "Error 3265 (Item not found in this collection.) in SplitSerials procedure at line 80" I tried changing line 80 to 80 SerialSplit = Split(rsSource!Serial, ",", -1) ' comma - change to other delimiter here. & now I get "Error 9 (Subscript out of...
  8. D

    Create Table Using Split Command

    Thank you for replying. I had got tired looking at it & had changed the procedure name to see if it helped me fix the problem, but I got sloppy & missed some, adding further confusion. I now have; ' Purpose : One field has comma delimited data - split them to multiple records ' Copy the...
  9. D

    Create Table Using Split Command

    Thank you for looking, but maybe I wasn't clear. I don't just want to import the data, I need to create new (otherwise duplicate) records for each individual serial number contained within the CSV data
  10. D

    Create Table Using Split Command

    Hi all, I'm looking for some help please on a create table macro that, after the initial run, can hopefully change to an append query. I need a macro that will trim & remove commas from the information in one field that existed in CSV format in an excel spreadsheet prior to import. I need to...
Top Bottom