[Webinar] Streamline your web hosting managementRegister Today

x
  • 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?
0
jc31415
Asked:
jc31415
1 Solution
 
BrianWrenCommented:
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'
SELECT *
FROM tbl_In_This_Db;

tbl_In_This_Db can also be a select query...

What do you need?

Brian
0
 
Green_BoyCommented:
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.

Green_Boy
0

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