Importing in backend through frontend

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
 
R

Ronald W. Roberts

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top