Automate Import of Spreadsheet to Backend from Frontend

[david_benge]

I am trying to create a macro or module to automate the importing of an Excel
spreadsheet as a table to a backend database while the user is in the
frontend database. I am trying to avoid the user opening the backend and
runing the automation from there (trying to simplify for novice users). I
have figured out how to import the spreadsheet to the frontend, but since all
of the tables are linked tables, I need to import the original in the backend
first, and then link the table to the frontend.

 

[pietlinden]

I am trying to create a macro or module to automate the importing of an Excel
spreadsheet as a table to a backend database while the user is in the
frontend database.  I am trying to avoid the user opening the backend and
runing the automation from there (trying to simplify for novice users).  I
have figured out how to import the spreadsheet to the frontend, but sinceall
of the tables are linked tables, I need to import the original in the backend
first, and then link the table to the frontend.

Wait a minute. By far the easiest way to handle this is to create a
table in the back end that will hold the data from the spreadsheet.
Then you can just create an import specification and run the import.j

You would just have to create a workspace in your front end, open the
backend database in the workspace, and then run the import. You are
not creating and deleting the table, I hope. If you are, don't. Just
use a delete query and then an append query. You could create a
linked table in the database to the SS and then run the import.