M
Mel
- I have a query (qryX) getting data from several tables.
- I need to export the results of this query to a comma delimited file
so I can load it into a spreadsheet (Excel)
- File > Export is grey'd out and not available.
- I mostly use the Access menu's and have not used much code.
I understand that this line of code will do the trick...
DoCmd.TransferText acExportDelim, "Standard Output", "External
Report", "C:\Txtfiles\MyText.csv"
- I think I can create a button on a form and put the DoCmd in the
Click event...
- BUT I only want to do this once... so I don't really need to create
a special menu and button.
My Question:
1 - How to modify the above DoCmd so that it get's data from my querry
qryX?
2 - How can I run the l "DoCmd" to output qryX as a csv file without
creating a button and a click event?
Thanks for any help.
- I need to export the results of this query to a comma delimited file
so I can load it into a spreadsheet (Excel)
- File > Export is grey'd out and not available.
- I mostly use the Access menu's and have not used much code.
I understand that this line of code will do the trick...
DoCmd.TransferText acExportDelim, "Standard Output", "External
Report", "C:\Txtfiles\MyText.csv"
- I think I can create a button on a form and put the DoCmd in the
Click event...
- BUT I only want to do this once... so I don't really need to create
a special menu and button.
My Question:
1 - How to modify the above DoCmd so that it get's data from my querry
qryX?
2 - How can I run the l "DoCmd" to output qryX as a csv file without
creating a button and a click event?
Thanks for any help.