Search results

  1. A

    Import .txt files with file name

    Can anyone help me with this? I keep getting a compile error syntax error with the select part of the statement...I dont know why....anyone??? please help... Option Compare Database Private Sub bImportFiles_Click() On Error GoTo bImportFiles_Click_Err Dim objFS As Object, objFolder As Object...
  2. A

    Import .txt files with file name

    Thanks, I caught that after posting...I am still getting a syntax error in the select statement...im not sure why but i am going through it again and trying to get it worked out...thanks again!
  3. A

    Import .txt files with file name

    I realize that I have my INSERT INTO and SELECT in the wrong order. When i move them to the right place, i still get a compile error...I really can't see what is wrong with this select statement... Thanks in advance for any help!
  4. A

    Import .txt files with file name

    Hi, I have searched on here and gotten most of the way with this problem. I want to import about 500 text files into one table but also add the file name as a field while importing. So far I have figured out that I should use a temporary table and then copy the data from there into my...
  5. A

    populate fields based on a date/time range in another table

    Actually, that won't work for what I have to do because they want the time to match to the closest time that the other table has...and when I round the time in the Location table, I get several records with one time stamp. Thanks for the advice though. I have been looking at some code for...
  6. A

    populate fields based on a date/time range in another table

    that is a really good idea...sometimes we overthink i guess... I will let you know how it goes
  7. A

    populate fields based on a date/time range in another table

    Hi, I have two tables, one with oceanographic data and a date/time stamp and one with location data and a date/time stamp. None of the date/time stamps match exactly and I want to match up the location data to the oceanographic data using a +/- 30 second time interval. I don't know how to use...
Back
Top Bottom