Rabu, 02 Mei 2012

RE: [MS_AccessPros] Report to Excel

 

Robin-

Export to Word, highlight the data in Word and choose Insert / Text / Convert
Text to Table. Copy the resulting table into Excel.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

----------------------------------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Tuesday, May 01, 2012 11:06 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Report to Excel

 
I have a club report with this SQL:

SELECT qClubs.NameOfClub, qClubs.Postal, qClubs.Meets,
qClubs.PlaceMeet, qClubs.Chartered, qClubs.SponsoredBy, qClubs.EmailAddress
FROM qClubs;

I have made a report where the data shows as:

NameOfClub
Postal
Meets
PalceMeet
CharteredBy
EmailAddress.

I need an XLS version in that format.

If I use 'Export' the data shows in the format:

NameOfClub, Postal, Meets, PalceMeet, CharteredBy, EmailAddress.

How do I arrive at an Excel output in the vertical list format?

Many Thanks,

Robin Chapple

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar