Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   Access to Excel Exporting Part data base (https://www.cableforum.uk/board/showthread.php?t=33603177)

Mike 07-11-2006 13:00

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

gazzae 07-11-2006 13:04

Re: Access to Excel Exporting Part data base
 
Create a query with the fields you want and export the query?

Saaf_laandon_mo 07-11-2006 13:04

Re: Access to Excel Exporting Part data base
 
Quote:

Originally Posted by gazzae (Post 34152367)
Create a query with the fields you want and export the query?

Thats what id do too.

Paddy1 07-11-2006 23:53

Re: Access to Excel Exporting Part data base
 
or just export the lot and then delete the ones you don't need.


All times are GMT +1. The time now is 12:05.

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