I want to upload a text file to a access database, but the string does not work. I guess the problem is with the quote marks or something of the sort.
The string is as follows:
rs.Open "SELECT * FROM [" & Me.Text1.Text & "] ", objConnection, adOpenStatic, adLockOptimistic, adCmdText
Text1.text is contains the name of the file to be put into the database.