[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1033
  • Last Modified:

Batch update to Access DB

I have an Access DB, which I would occasionally like to update with a lot of data. I know I can do that by importing into a table, but is there another way by using a form or something to allow another user to do it in a controlled way?
1 Solution
Well . . .

You can have them export into the DB in question.

You can use an Append query to append records onto the end of the existing data:

INSERT INTO tbl_In_Other_Db IN 'c:\Other_DB.mdb'
FROM tbl_In_This_Db;

tbl_In_This_Db can also be a select query...

What do you need?

By importing data into a table you can still build it in a controlled way and very easily. You would just have to create import layout design and then create a macro that would access import layout design a.k.a. "SPECIFICATION NAME" , specify the table that you want to import into , specify the file name , and put yes for field names. You can access this macro with a button on a panel. If would like details for this answer let me know.


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now