Hi Guys,
I've been building a userform to interact with an access database through excel. I've not at too much experience with ADO in excel so far but have managed to make it so it does the following:
- Searches and pulls specific record based on specific unqiue id
- Dumps whole record on an excel row
- Loads excel row in userform
- Made userform to append excel row with updates.
I was thinking / wanting to them put that excel row back into append the specific access record it came from in the same place.
To do:
Excel Row >> Access Record/Row (all same format / layouts in cells, as exact access record was pulled origionally).
Is there any way which I can do this through ADO in VBA? I've been struggling in searching for ways to do so far.
Currently using Excel 2007 / Access 2007, although some users would be using Excel 2003.
I've been building a userform to interact with an access database through excel. I've not at too much experience with ADO in excel so far but have managed to make it so it does the following:
- Searches and pulls specific record based on specific unqiue id
- Dumps whole record on an excel row
- Loads excel row in userform
- Made userform to append excel row with updates.
I was thinking / wanting to them put that excel row back into append the specific access record it came from in the same place.
To do:
Excel Row >> Access Record/Row (all same format / layouts in cells, as exact access record was pulled origionally).
Is there any way which I can do this through ADO in VBA? I've been struggling in searching for ways to do so far.
Currently using Excel 2007 / Access 2007, although some users would be using Excel 2003.
Last edited:
