Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Access to Excel Exporting Part data base

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion

Access to Excel Exporting Part data base
Reply
 
Thread Tools
Old 07-11-2006, 13:00   #1
Mike
Inactive
 
Join Date: Jan 2004
Age: 63
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Access to Excel Exporting Part data base

Hi all

I have an access data base containing about 15 fileds and I would like to export some of the fields (7) into excel.

I tried the Tools /Office links / excel but that exports all the fileds. Is it possible to choose which fields are exported and if so how ???

Many thanks for your time


Mike
Mike is offline   Reply With Quote
Advertisement
Old 07-11-2006, 13:04   #2
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Access to Excel Exporting Part data base

Create a query with the fields you want and export the query?
gazzae is offline   Reply With Quote
Old 07-11-2006, 13:04   #3
Saaf_laandon_mo
Inactive
 
Join Date: Nov 2005
Posts: 4,291
Saaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny star
Saaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny starSaaf_laandon_mo has a nice shiny star
Re: Access to Excel Exporting Part data base

Quote:
Originally Posted by gazzae View Post
Create a query with the fields you want and export the query?
Thats what id do too.
Saaf_laandon_mo is offline   Reply With Quote
Old 07-11-2006, 23:53   #4
Paddy1
cf.addict
 
Join Date: Jul 2004
Posts: 351
Paddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond repute
Re: Access to Excel Exporting Part data base

or just export the lot and then delete the ones you don't need.
Paddy1 is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 15:08.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum