Hi,
I know I'm asking alot here, but is there anyone out there that has a small Access data base that they use to get imformation from through Excel? I want to learn how to use Excel to display data from Access. What I'm most interested in, is how to get records that are sorted in access,and then displayed in Excel. I have tried to record a macro to do this, but if leves more questions than answers as to how to alter or manipulate the different fields that I want.
A bonus would be is an example on how to add records to the MDB from Excel as well.
I know its a tall order, but maybe by chance someone has something they could share.
Thanks so much for your time,
Jim
I know I'm asking alot here, but is there anyone out there that has a small Access data base that they use to get imformation from through Excel? I want to learn how to use Excel to display data from Access. What I'm most interested in, is how to get records that are sorted in access,and then displayed in Excel. I have tried to record a macro to do this, but if leves more questions than answers as to how to alter or manipulate the different fields that I want.
A bonus would be is an example on how to add records to the MDB from Excel as well.
I know its a tall order, but maybe by chance someone has something they could share.
Thanks so much for your time,
Jim