By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Export portion of Access table to Excel

P: n/a
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

Aug 17 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
<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
Aug 17 '06 #2

P: n/a
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
Aug 18 '06 #3

P: n/a
"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
Aug 18 '06 #4

P: n/a
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

Aug 21 '06 #5

P: n/a
"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.
Aug 21 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.