var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am trying to export a query to csv file.
At the click of a button on a form, I need info in a query (qEndOfYearIRS) exported to c:\ as a .csv file.
This is what I have right now. What am I doing wrong?
Dim stDocName As String
stDocName = "qEndOfYearIRS"
'DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.OutputTo acOutputQuery, "qEndOfYearIRS", "c:\EndOfYearIRS.csv", True
I always use the TransferText method of the DoCmd object. I would also suggest trying to get a macro to work. Sometimes the extra help in the macro setup will you figure out the appropriate parameters for a given method.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors