Query for making XLS from data

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have this data in a table.... What I need to do is export this to an excel
spread sheet with the Part type ie..Acuson.. as being listed as the TAB and
the part description i.e...DBL PCB, OC2 PCB and so on as being listed in the
columns. Is there a way to do this?


DBL PCB Acuson
OC2 PCB Acuson
Main System Cont PCB AI
IMEM PCB AI
RTC PCB AI
CFM Interface PCB AI
FEC PCB AI
DVP PCB AI
PANAL FACE AI
Doppler Interface PCB AI
FOCUS MODULE PCB AI
Transducer Interface PCB AI
Wide Bus Memory PCB Apogee
Beamformer Focus PCB ATL
 
To rename the tab from Access will require VBA. Add a reference to the Excel
Object Library.

While you're there(in code), just write the data.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
I am not sure how to go about this. Is there a reference web page or
something simple you would walk me through?
 
Back
Top