Transfer Data to specific columns in Excel

  • Thread starter Thread starter Tamer Seoud
  • Start date Start date
T

Tamer Seoud

Hi,
I have a query that I want to output some values on it to
some cells in an Excel spreadsheet. In another word, how
to specify some records in my query to be output to
specific cells in an Excel spreadsheet?
Please advise
Thanks a lot.
 
ActiveWorksheet.Row(n).Col(n).value = "Specific Value"

But, this requires VBA.


--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thank you for your response. I still have an inquiry on
how to specify a column in the Access query to be output
to a certain column in the Excel spreadsheet. I have no
problem with outputting the entire query to the excel file
through:
DoCmd.OutputTo acQuery, "qry_SE_Info", "MicrosoftExcel
(*.xls)", "c:\Test1.xls", False, ""

My problem is that I want to output only (one data field)
in Access to (K column) in the Excel file without
affecting the other columns in the Excel file.

Thanks a million
 
Back
Top