export one column to excel 3

[JoanaSantos]

Hi,

how can I export one column from access to excel? using access vba

thanks

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

So you want to get a column of data into Excel.

I'd do it all directly in Excel, running an automatic query to pull that data in from your Access table each time the workbook opens. That would give the user(s) the latest up-to-date list.

Check out Data > Get External Data

 

[JoanaSantos]

Ok I will try thaaank u )