Recent content by Brad VTP

  1. B

    Access VBA - Deleting a line in a CSV

    Thanks, Isaac and namliam! Yes, we are going to try Isaac's routine. I completely agree, that the testing process will be more efficient. Currently, after selecting the file, the data processes into a temporary table so it can be given a "once over" QC review. We have a second routine built...
  2. B

    Access VBA - Deleting a line in a CSV

    We are trying to process a CSV file into an Access table where the first line contains an instruction code "sep=^" (quotation marks only shown here to distinguish the text found in the first line; they are not contained in the file) that presumably indicates that the separator between fields is...
Top Bottom