Recent content by johnson

Thanks Simon, I've finally resolved this. I had missed that strBuffer brain fart and a couple other things as well. The special character issue you saw was nasty. I ended up trimming the first X amount of characters that will remain constant and then splitting that.

Chr(8) is backspace Chr(9) is tab (ref. asciitable.com) Ubound is returning 0, so it's not even getting to the split with the first line I think.

What you describe is EXACTLY what the code i've posted is supposed to do, but it doesn't work.

Thanks, however the file can be enormous and shouldn't be imported unless the number of fields can be verified as well as the correct names for them.

I'm trying to verify: 1) How many fields are present before importing a csv file 2) If the number of fields is correct, are the field names correct as well The CSV file uses tab as the delimiter with no text qualifier. If the CSV is verified as correct, the append query is run, transferring...