Excel data to Access
 

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!

Excel data to Access
 

go to access and you can import the file or link to it.

Regards,
Tom Ogilvy


"newbie" wrote in 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!

Excel data to Access
 

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!
.

.