Import data to Back End from the Front End

[Guest]

I want to import data into our back end database and link it to the front
end. The trick is to do it from the front end via a form.

I want the end user to be able to import a spreadsheet into the back end
that is updated every 2 weeks with new information and keep the link to the
table. Any thoughts?

 

[John Nurick]

It's fairly simple. Here's one way:

Create a table in the back end with the correct fields and field names.

In the front end, create a linked table (linked to the new table in the
back end). Then, in the front end, import the data into the linked
table.

When the updated spreadsheet arrives, first - if necessary - run a query
to delete the records from the linked table; then import the new data.

 

[Guest]

I would suggest that you create a table in the backend with the fields you
need to accept data from the spreadsheet. Then, whenever you need to add
data to it from the spreadsheet, instead of importing it, link to it, create
an append query that will append data to your table from the spreadsheet,
then delete the links when it is done.