Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Table import
What kind of code could I use to import a table from access to a
worksheet in excel? I'm thinking of opening the database, opening the table, select all, copy, and then pasting into my excel file. Is there an easier way to do this? The Access table will change on a weekly basis, I want to be able to reload the new info (into Excel) at the push of a button. Maybe some kind of office links combo? Any help is appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Table import
What you are looking for is to query the table and bring back all records.
Data - Import External Data - New Database Query. Keep in mind that XL maxs out at 65,536 rows so your table can not exceed that number of records. If it does then you need to define some criteria for your query or you can connect a pivot table to the database and then you are no longer constrained to 65,536 records. -- HTH... Jim Thomlinson "SmartyPants" wrote: What kind of code could I use to import a table from access to a worksheet in excel? I'm thinking of opening the database, opening the table, select all, copy, and then pasting into my excel file. Is there an easier way to do this? The Access table will change on a weekly basis, I want to be able to reload the new info (into Excel) at the push of a button. Maybe some kind of office links combo? Any help is appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Access Table into Excel. I appreciate your assistance. Thanks! | Excel Discussion (Misc queries) | |||
Import Access Table into Excel | Excel Worksheet Functions | |||
import excel to access table | Excel Programming | |||
Import from Access to Excel, via pivot table | Excel Discussion (Misc queries) | |||
I can import Access Tables. But, I can't import Access queries | Excel Programming |