fraser_lindsay
Access wannabe
- Local time
- Today, 23:42
- Joined
- Sep 7, 2005
- Messages
- 218
Hello,
I would like to create a routine which will import details from a number of columns in a defined Excel worksheet into my access table. I would like it to add new details and update exisiting details based on name.
I know I have to use some extensive VBA programming only my skills are quite there yet. I have had some greta advice form this site and a basic "Access VBA for dummies' book but I still don't really know how to get this started. It's maybe a bit more advanced than I intended but it is something I now require to stay up to date with my database details.
Does anybody have a similar block of code that does this already, even in its most basic form i.e. one column in Excel to Access? I wodul like to see how it is put together to allow me to learn and build upon it.
Thanks
I would like to create a routine which will import details from a number of columns in a defined Excel worksheet into my access table. I would like it to add new details and update exisiting details based on name.
I know I have to use some extensive VBA programming only my skills are quite there yet. I have had some greta advice form this site and a basic "Access VBA for dummies' book but I still don't really know how to get this started. It's maybe a bit more advanced than I intended but it is something I now require to stay up to date with my database details.
Does anybody have a similar block of code that does this already, even in its most basic form i.e. one column in Excel to Access? I wodul like to see how it is put together to allow me to learn and build upon it.
Thanks