I use the following code to import a csv file into my database:
Private Sub cmdImport_Click()
On Error GoTo Err_cmdImport_Click:
Dim dbs As Database
Dim strSQL As String
DoCmd.SetWarnings False
Set dbs = CurrentDb
DoCmd.TransferText acExportDelim, "DelimWO-1", "tblImported", "C:\Users\AllPC\Downloads\Service-requests-08-22-18"
Exit Sub
Err_cmdImport_Click:
MsgBox Err & " " & Err.Description
End Sub
The table tblImported is already created (otherwise I get an error that it cant find it!)
When I run the program I get: 3027 Cannot Update. Database Object is Read-Only. I tested the table tblImported and it is NOT read-only
Any ideas?