Import & Export Table,Query To Excel

[AsifShah]

Hello Friends,

I want to export data from my table query to Excel and also import data from Excel using my userform button. need code Please help.

 

[welshgasman]

I take it you have not even tried to Google?
Export:

export access to excel - Google Search

Import:

export excel to access - Google Search

Import:

import to access from excel - Google Search

 

[welshgasman]

Here is another clue

DoCmd.TransferSpreadsheet method (Access)

Office VBA reference topic

learn.microsoft.com