Export wizard

  • Thread starter Thread starter netalie
  • Start date Start date
N

netalie

Hi,

I'm using the export wizard to export data from access to
a text file, and my export settings are always the same.

is there a way that i can code this action other then use
the wizard every time?

Thanks
 
Netalie,

Start the manual process once more, and while in the export wizard, just
before finish, click on Advanced, Save as to save your export
specification... and write down the spec name.

Then make a new macro with an action TransferText (you'll need the spec name
here). All you need to do next time is run the macro.

HTH,
Nikos
 
firstly, thanks,
i have a problem running it though, it gives me the erro
of a read only object. i'm logged in as admin.
what is the problem?
 
firstly, thanks,
i have a problem running it though, it gives me the erro
of a read only object. i'm logged in as admin.
what is the problem?
 
Try deleting the old exported Text file first before exporting again.

Post your VBA code if you still have problems
 
still same error...
here is the code:

Function Macro11()
On Error GoTo Macro11_Err

DoCmd.TransferText acExportDelim, "aaa Export
Specification", "tablename", "c:\output", False, ""


Macro11_Exit:
Exit Function

Macro11_Err:
MsgBox Error$
Resume Macro11_Exit

End Function
 
found the problem,

thanks!!!!
-----Original Message-----
Try deleting the old exported Text file first before exporting again.

Post your VBA code if you still have problems

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
Back
Top