Importing in backend through frontend

  • Thread starter Thread starter Bakema
  • Start date Start date
B

Bakema

Hi there,

My clients need to import on a regular basis an Excel
file into the backend of their database. Of course I
would like to avoid that they have to open the backend
for that purpose, so I have been looking for a simple,
largely automated, procedure that can be run from the
frontend. The excel table itself can go straight into a
table in the backend without any further manipulation.

My approach has been to use the 'get external data'
dialogue on the frontend, however this does not give me
the linked tables in the backend to import into. What
other possibilities are there to import into the backend
from the frontend in a simple manner.

Thanks for some thoughts and solutions

Bakema
 
Bakema said:
Hi there,

My clients need to import on a regular basis an Excel
file into the backend of their database. Of course I
would like to avoid that they have to open the backend
for that purpose, so I have been looking for a simple,
largely automated, procedure that can be run from the
frontend. The excel table itself can go straight into a
table in the backend without any further manipulation.

My approach has been to use the 'get external data'
dialogue on the frontend, however this does not give me
the linked tables in the backend to import into. What
other possibilities are there to import into the backend
from the frontend in a simple manner.

Thanks for some thoughts and solutions

Bakema

You can import it into a temp table in the front-end and
then
use an append query to add the records to a table in the
back-end
that has already been linked. You can also use a delete
query to
delete all of the reords in the back-end before you append
the new
records. When the process is complete, delete all of the
records in the
temp table in th efront-end.

Ron
 
Back
Top