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
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