Hi All,
This is my first post on this forum... I'm hoping someone here can help me with this...
I'm trying to transfer data from a shared access .mde file into an excel worksheet using vba in Excel.
Ive seen numerous samples of code on the net on how to connect to the source .mdb file and copy records from the table.
My problem is that the .mde file doesn't store the table. The values are only accessible through the form.
(so the ADO open table soure doesn't work, see
http://www.erlandsendata.no/english/index.php?d=envbadacimportado)
I can do a manual Copy of the values from the form using "Datasheet view" which displays all the values in table view, and then pasting them into
Excel, so I believe this can be automated with VBA, If I can get the commands to access the form rather than table, does anyone have any Ideas?
Regards,
Sherif
This is my first post on this forum... I'm hoping someone here can help me with this...
I'm trying to transfer data from a shared access .mde file into an excel worksheet using vba in Excel.
Ive seen numerous samples of code on the net on how to connect to the source .mdb file and copy records from the table.
My problem is that the .mde file doesn't store the table. The values are only accessible through the form.
(so the ADO open table soure doesn't work, see
http://www.erlandsendata.no/english/index.php?d=envbadacimportado)
I can do a manual Copy of the values from the form using "Datasheet view" which displays all the values in table view, and then pasting them into
Excel, so I believe this can be automated with VBA, If I can get the commands to access the form rather than table, does anyone have any Ideas?
Regards,
Sherif