Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 02-08-2012, 05:03 AM   #1
Newly Registered User
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Kacker is on a distinguished road
Exclamation Import+Update

Hello there,

I was wondering if anybody could help me out with a little problem. I'm absolutely new to Access and VBA (never ever touched the stuff before). I have a database structure ready into which I need to to put in data from an Excel worksheet using VBA? How could I do this most easily?

Additionally, I need to include the functionality in the code for updating the database. For instance, if in the future I wanna update the Access table using an updated Excel worksheet, I would like to search the existing data and only import the new fields.

Could somebody help me out here?




Kacker is offline   Reply With Quote
Old 02-08-2012, 05:19 AM   #2
Newly Registered User
Join Date: Apr 2007
Location: Bristol, UK
Posts: 751
Thanks: 2
Thanked 47 Times in 47 Posts
tehNellie will become famous soon enough
Re: Import+Update

Might not need VBA depending on what you're trying to achieve and how the data is structure in excel.

Creating a linked table to your excel spreadsheet and a couple of queries to import/update the data in your access table(s) might be enough to achieve what you're trying to do.
tehNellie is offline   Reply With Quote
Old 02-08-2012, 02:39 PM   #3
Super Moderator
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,771
Thanks: 118
Thanked 1,546 Times in 1,451 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Import+Update

Only one query required. An update query will also insert new records if the join type is set correctly (arrow from the imported table to the destination table in the designer).

Galaxiom is offline   Reply With Quote

access , excel , import , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update after import is not working ria_arora Modules & VBA 3 04-04-2011 08:38 PM
Import and update data JamesL Tables 1 09-13-2010 08:23 AM
import and update excel spreadsheet eugz Modules & VBA 1 08-05-2008 05:48 AM
Import XL and Update fields Sparky Fluff Modules & VBA 2 07-15-2007 03:10 PM
Import/Update table from Excel ? pookie62 Tables 3 01-17-2005 09:24 AM

All times are GMT -8. The time now is 10:41 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World