transfering data from different queries to on excel file in different sheets

[tawkkal]

hi.. friends...

I m access user... i have made some queries.. & want to transfer data from different queries to on excel file in different sheets.. I have tried transfersheet macro... but... it transfers with one inverted coma in text column.. due to this the data exported to excel is no use to me.. as i m not able to upload the same to another application or even apply vlook in excel which is my basic purpose for doing this entire thing....

Can any body help me in this...

 

[SRAB]

Instead of "transfersheet macro", try "OutputTo". I use this to run queries that output to spreadsheets.

 

[Uncle Gizmo]

There is a thread here that may provide some help