Export data to Excel Column

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Currently I export data to excel using the sql statment:

SELECTTable1.Field1 INTO [Excel 8.0;HDR=Yes;DATABASE=C:\File.xls].Sheet1
FROM Table1 WHERE (((Table1.Field2)=2));
DoCmd.RunSQL

I run the sql statement multiple times, changing the "Sheet1" data to create
new sheets in the same exel file.

Is there a way to export to the same excel file, same sheet, different column?
For example IO want to run the sql statment and populate columnA, run it a
second time and populate columnB, etc..

Any assistance will be appreciated.
 
Currently I export data to excel  using the sql statment:

SELECTTable1.Field1 INTO [Excel 8.0;HDR=Yes;DATABASE=C:\File.xls].Sheet1
FROM Table1 WHERE (((Table1.Field2)=2));
DoCmd.RunSQL

I run the sql statement multiple times, changing the "Sheet1" data to create
new sheets in the same exel file.  

Is there a way to export to the same excel file, same sheet, different column?
For example IO want to run the sql statment and populate columnA, run it a
second time and populate columnB, etc..

Any assistance will be appreciated.
Click to expand...

read this article:
http://www.mvps.org/access/modules/mdl0035.htm
 
Back
Top