Export textfile from access 2007

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I try to export a textfile in access 2007 using the text exort guide. This
textfile has to have extension .gen but it doesen't work. I get a read only
error 3027. In access 2003 it was easy to change in registre so access
accepped filenamn.gen. Can anybody help me to fix this in access 2007
 
Nick said:
I try to export a textfile in access 2007 using the text exort guide. This
textfile has to have extension .gen but it doesen't work. I get a read
only
error 3027. In access 2003 it was easy to change in registre so access
accepped filenamn.gen. Can anybody help me to fix this in access 2007
Click to expand...

Perhaps you export as .txt, and then use the re name command? While not
perfect, this suggestion would "eliminate" the need for some registry edit
like you were doing previous.....


dir strOutputFText as string
dim strOutputGen as string

strOutputFtext = "c:\my data\output.txt""
strOutputGen = left(strOutput,len(strOutput) - 3) & "gen"

Name strOutPutFtext as strOutputGen

the "file rename" command in access is called "name" as per above....
 
Back
Top