Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data from an Access DB with VBA
Is there a primer on how to do this? I want to import specific ranges of
records from an access table. Thanks, Sandy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Data from an Access DB with VBA
The best thing to do is to get a good book on Access VBA. The Access VBA commands can be used in Excel VBA with a few minor changes. Depending on the version of Access you are using depends on which commands will work. Access is not like Excel that most commands will work in any version of Excel. With Acces you can use the Microsoft Jet engine or use ADO or DAO methods depending on how the database was created. 1) In Excel declare an Access Application Set obj = CreateObj("Access.Application"). the include obj in front of the Access commands yo get from the book. 2) In excel specify a reference to Access by going to the following menu Tools - References - Microsoft Access 11.0 Object Library 3) Depending on the methods you use in Accdess you may have to add the Active X library object to your project Tools - References - Microsoft ActiveX Data Objects 2.8 Library The two tricks I use is to Reference the Access VBA help for finding methods. There are a lot of good examples in the Access VBA Help. I also use the Excel macro recorder and first try to record will performing the following actions in excel From worksheet menu in excel : Data - Import External Data - Import Data (or new web query) and select the Access Source File. The last menu (the one with finish) has an option to edit the query where you will see the SQL statements for the query. The "Command Text" portion of the recorded macro is the SQL statements and can be edited as required. If you have experience writing SQL statements the task should be pretty simple once you have the recorded macro to get you started. "Sandy" wrote: Is there a primer on how to do this? I want to import specific ranges of records from an access table. Thanks, Sandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from Access | Excel Discussion (Misc queries) | |||
Can't import data to access | Excel Discussion (Misc queries) | |||
Import - Access Data through ADO | Excel Programming | |||
Import Data From Access! Please Help!! | Excel Programming | |||
Import Data from Access via DAO | Excel Programming |