Talk About Network

Google





Software > Access External data > Ex****t data to...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 11303 of 11376
Post > Topic >>

Ex****t data to Excel Column

by =?Utf-8?B?SnVzdGlu?= <Justin@[EMAIL PROTECTED] > Nov 30, 2008 at 06:23 PM

Currently I ex****t 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 ex****t 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.
 




 2 Posts in Topic:
Export data to Excel Column
=?Utf-8?B?SnVzdGlu?= <  2008-11-30 18:23:21 
Re: Export data to Excel Column
"pietlinden@[EMAIL P  2008-11-30 21:42:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Thu Jan 8 15:40:39 PST 2009.