Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import access data into excel | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Data from Access to Excel | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
Importing Data from Access into Excel | Excel Discussion (Misc queries) |