Leo_Polla_Psemata
Registered User.
- Local time
- Today, 00:17
- Joined
- Mar 24, 2014
- Messages
- 364
Hi ,
I have a simple query and I want to export it in excel, Coma Separated Value., .CSV
I tried to run DoCmd.TransferText but all of my attempts were futile.
Is there any idea about it ?
Thanks
Edit
I found it, I must export it as TXT and file suffix insert .csv instead of .txt and it works
Now, does anyone know if I can execute this "Saved Exports" through a macro or docmd ?
Another edit, i insert a picture just to make it more clear.
Can I run this "Saved Exports" through a macro or docmd ?
[img=http://s16.postimg.org/fhfuqxm5d/Untitled.jpg]
I have a simple query and I want to export it in excel, Coma Separated Value., .CSV
I tried to run DoCmd.TransferText but all of my attempts were futile.
Is there any idea about it ?
Thanks
Edit
I found it, I must export it as TXT and file suffix insert .csv instead of .txt and it works
Now, does anyone know if I can execute this "Saved Exports" through a macro or docmd ?
Another edit, i insert a picture just to make it more clear.
Can I run this "Saved Exports" through a macro or docmd ?
[img=http://s16.postimg.org/fhfuqxm5d/Untitled.jpg]
Last edited: