Export portion of Access table to Excel

[daicakien]

hi everybody,
im developing access db. my user want to export some column of the
table( in access) to Excel( he may choose from list box of form). do
you have any idea about it?
thanks

[Keith Wilby]

<da*******@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

hi everybody,
im developing access db. my user want to export some column of the
table( in access) to Excel( he may choose from list box of form). do
you have any idea about it?
thanks

Give your user a datasheet (form) view with "Show/Hide Columns" and "Analyze
with Excel" menu items.

Regards,
Keith.
www.keithwilby.com

[ddk]

Thanks Keith for your info. im just a newbie, still blur with your
suggestion. can anyone help to tell me more details?
thanks a lot
Keith Wilby wrote:

<da*******@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

hi everybody,
im developing access db. my user want to export some column of the
table( in access) to Excel( he may choose from list box of form). do
you have any idea about it?
thanks

Give your user a datasheet (form) view with "Show/Hide Columns" and "Analyze
with Excel" menu items.

Regards,
Keith.
www.keithwilby.com

[Keith Wilby]

"ddk" <da*******@gmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

Thanks Keith for your info. im just a newbie, still blur with your
suggestion. can anyone help to tell me more details?
thanks a lot

Design a new form using your table as its data source. Make the default
view "datasheet".

When you open the form to display the data, make sure that the menu itmes I
mentioned in my other post are available. If they're not then customize
your menus as you would in any other Office app.

Keith
www.keithwilby.com

[ddk]

Thanks Keith, another problem i think i didnt state is he wants columns
are extracted to excel in his order. mean that sometimes he want to
extract id, name, possition, somtimes position, name in particular
order. that the reason i think about VBA. Do you have any idea?
thanks in advance

[Keith Wilby]

"ddk" <da*******@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

Thanks Keith, another problem i think i didnt state is he wants columns
are extracted to excel in his order. mean that sometimes he want to
extract id, name, possition, somtimes position, name in particular
order. that the reason i think about VBA. Do you have any idea?
thanks in advance

IIRC, you can order the columns by dragging and dropping, same as you would
in Excel.

Keith.