Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing access mdb in to excel
i have an .mdb file (Prova.mdb) with 2 table (TABLE1 and TABLE2)
could want to import TABLE1 into SHEET1 and TABLE2 into SHEET2 how t make it with a macro in VBA for Excel, is possible -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing access mdb in to excel
Excel cannot read Access files. I think Access can create Excel files, so
you might approach it from that side. -- Jim Rech Excel MVP "sal21 " wrote in message ... |i have an .mdb file (Prova.mdb) with 2 table (TABLE1 and TABLE2) i | could want to import TABLE1 into SHEET1 and TABLE2 into SHEET2 how to | make it with a macro in VBA for Excel, is possible? | | | --- | Message posted from http://www.ExcelForum.com/ | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing access mdb in to excel
Although Access Files will not show as an option when
opening files (and therefore cannot be imported that way) there is another way to get Excel to bring in Access tables. From the Data menu choose "Get External Data" and then "New Database Query." A list of Databases will show with MS Access Database as an option. Choose this, specify your file location, and you will see a list of your tables and queries. Choose the table or query you want to import and it will bring it into Microsoft Query, where you can either import the entire table/query or use your Access data as a basis for a new query. See MS Query help for details if you can't figure it out. When done, you choose to "Return Data to Microsoft Excel" and specify where to put it. Then the option "Refresh Data" (in the Data menu) will update the data any time you need to reimport it (and this can be controlled by a macro). There is a lot more detail to it, but it is not too hard to figure out and help or the MSDN library/Knowledge Base or these newsgroups should help if you run into any specific questions. Hope this helps! Ken -----Original Message----- Excel cannot read Access files. I think Access can create Excel files, so you might approach it from that side. -- Jim Rech Excel MVP "sal21 " wrote in message ... |i have an .mdb file (Prova.mdb) with 2 table (TABLE1 and TABLE2) i | could want to import TABLE1 into SHEET1 and TABLE2 into SHEET2 how to | make it with a macro in VBA for Excel, is possible? | | | --- | Message posted from http://www.ExcelForum.com/ | . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem importing Excel to Access | Excel Worksheet Functions | |||
Importing from access to excel | Excel Discussion (Misc queries) | |||
Importing to Excel from Access | New Users to Excel | |||
importing/exporting from access to excel | Excel Discussion (Misc queries) | |||
Importing to access from excel | Excel Discussion (Misc queries) |