Importing text files into a Backend database using the Frontend

[ddelk]

I am getting text files dumped to a folder and I need to bring those into a backend database. I am trying to figure out how to do a call to docmd.transfertext from the frontend that brings the files into the backend.

 

[bkclaw113]

Try something like this

Public Sub runOther(strDBPath As String)
Dim acApp As Access.Application

Set acApp = New Access.Application
acApp.OpenCurrentDatabase (conDBPath)
acApp.DoCmd.OpenQuery "Query1", acViewNormal

[COLOR=green]'Cleanup[/color]
acApp.Quit
Set acApp = Nothing
End Sub

 

[earthandfire]

If the table in the backend exists and is linked to the frontend, then you should be able to run TransferText from the frontend without any problems.