Easily how? I want to do it programically (in
VB).
-----Original Message-----
From ACCESS you can easily link to an excel table.
In Excel you'd have to loop & push the data from a table
in line by line --- but if you're populating a recordset
then yuo don't actually push the data to Access until you
fire the UPDATE method.
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
I'm new to VBA so bear with me... I need to take the
information contained in an Excel worksheet and store it
in an Access table. I really want to avoid the
situation
where I would go line by line and column by colum
because
it's just too slow. Is there some function I can use to
accomplish this? Any help in this matter would be
greatly
appreciated! Thanks a lot in advance!
.
.