Access data export into Excel as the data linked to excel.

[vinwin06]

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

Like we have some codes for linking excel file to database mentioned below;

DoCmd.TransferSpreadsheet acLink, , "region", "F:\DB Practice\Book1.xlsx", False, "region"

Can we have something like this to link database table in excel file automatically.

So that the excel size won't be that big and also it saves processing time.

 

[apr pillai]

Check this out: MS-Access Live Data in Excel

 

[vinwin06]

Actually i am looking for vice versa logic like linking excel file from access thorough access vba codes.

 

[apr pillai]

I think you need this: Opening Excel Database directly

If you plan to link excel table with VBA then you can get the sample code from here: Link External Tables with VBA

 

[John Big Booty]

Please refrain from deleting threads once they have been answered as this shows a total disrespect for those who have given their time to help you with your problem.

 

[vinwin06]

I didnot get the desired answer but i am respecting their efforts. I dont know where to mark as solved.