by "pietlinden@[EMAIL PROTECTED]
" <pietlinden@[EMAIL PROTECTED]
>
Nov 30, 2008 at 09:42 PM
On Nov 30, 8:23=A0pm, Justin <Jus...@[EMAIL PROTECTED]
> wrote:
> Currently I ex****t data to excel =A0using the sql statment:
>
> SELECTTable1.Field1 INTO [Excel
8.0;HDR=3DYes;DATABASE=3DC:\File.xls].She=
et1
> FROM Table1 WHERE (((Table1.Field2)=3D2));
> DoCmd.RunSQL
>
> I run the sql statement multiple times, changing the "Sheet1" data to
cre=
ate
> new sheets in the same exel file. =A0
>
> Is there a way to ex****t to the same excel file, same sheet, different
co=
lumn?
> 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.
read this article:
http://www.mvps.org/access/modules/mdl0035.htm
