Improve ADO code, Export Excel to Access
SteveC wrote ...
How can I get ADO to pull all my excel worksheet data
into Access? I've tried adjusting KeepItCool's macro
(see below) but it doesn't work. The hour glass runs
for a split second and then stops. No errors. But no data is imported into Access.
I see:
DROP TABLE DUMP
and
INSERT INTO dump ...
but no
CREATE TABLE DUMP ...
And you don't seem to be calling sub procedure XLS2MDB anyhow.
Jamie.
--
|