Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-08-2012, 05:03 AM   #1
Kacker
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?

Thanks!

Regards,

AK

Kacker is offline   Reply With Quote
Old 02-08-2012, 05:19 AM   #2
tehNellie
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
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,563
Thanks: 88
Thanked 1,479 Times in 1,395 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 online now   Reply With Quote
Reply

Tags
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 01:54 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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