Export as *.*

[salmanjavaheri]

Hi, how can I export some data as a text file, but change the
extension to something else? eg. *.pbk?, also how can i use the
command line in vba?


TIA

 

[Jerry Whittle]

Function fExportCargo()
DoCmd.OutputTo acOutputTable, "Cargo", acFormatTXT, "N:\Cargo.pbk"
End Function

 

[Alex Dybenko]

Hi,
you can export file as txt and then rename it to any extension using Name
Statement

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[salmanjavaheri]

thanks! how do i use a command line statement in vba? so that i can
open this file from inside access?

 

[salmanjavaheri]

thanks! how do i use a command line statement in vba? so that i can
open this file from inside access?

 

[Alex Dybenko]

Hi,
in order to use command line - you can use Shell() function

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[salmanjavaheri]

Can i use a this function or similar to export a single field from a
form into a file?