Search results

  1. J

    Import from a folder with file names

    This is the code that used: Private Sub bImportFiles_Click() On Error GoTo bImportFiles_Click_Err Dim objFS As Object, objFolder As Object Dim objFiles As Object, objF1 As Object Dim strFolderPath As String strFolderPath = "C:\Import TXT files\" Set objFS =...
  2. J

    Import from a folder with file names

    Here is the situation. I am connecting to a SQL database. This Db already has records. For each record, there is a field which needs to be updated with the content of the text file. SQL db has the field with the filename, which i was planning to use to join two tables.
  3. J

    Import from a folder with file names

    Hi everyone, I have a folder of text files. Text files have quite a bit of text in it (over 30,000 characters). I am trying to import those files into a table along with the file name. So the table imported into Access would have two columns: FileName and FileContent. FileName is Short Text and...
Back
Top Bottom