Import+Update (1 Viewer)

Kacker

New member
Local time
Today, 20:02
Joined
Feb 8, 2012
Messages
1
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
 

tehNellie

Registered User.
Local time
Today, 19:02
Joined
Apr 3, 2007
Messages
751
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.
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 06:02
Joined
Jan 20, 2009
Messages
12,849
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).
 

Users who are viewing this thread

Top Bottom