UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> Export To Pipe Delimited, Office 2000    
 
   
dsabol2000
post Mar 4 2010, 06:47 AM
Post#1



Posts: 217
Joined: 28-February 05
From: Pennsylvania


How can I export a table to a pipe delimited file? I'll ultimately need to automate this process, as well. Others will be running this.
Go to the top of the page
 
Peter46
post Mar 4 2010, 06:54 AM
Post#2


UtterAccess VIP
Posts: 7,489
Joined: 3-October 05
From: Oadby Leics, UK


You need to go through the export process manually and create a specification as you do so.
Use the Advanced button on the export dialog.
You can then create a macro or code procedure using Transfertext in which you use the specification.
Go to the top of the page
 
dsabol2000
post Mar 4 2010, 08:52 AM
Post#3



Posts: 217
Joined: 28-February 05
From: Pennsylvania


Great! Thanks! I forgot I've used that in the past. (a long time ago).
One final question, do you know if it's possible to have it change the file name when it's run? This is for a report to generate a file each month. The file name is required to have the month, that the data represents, in the name...is there a way to automate that or is it best to have the user make that change each time it's run?
Go to the top of the page
 
Peter46
post Mar 4 2010, 08:59 AM
Post#4


UtterAccess VIP
Posts: 7,489
Joined: 3-October 05
From: Oadby Leics, UK


If you use docmd.Transfertext in code then you can build the filename from expressions.
You can't do that witha macro.
ocmd.TransferText acExportDelim,"spec","queryname","C:\folder\File" & format(date(), "yyyymmm") & ".txt", true
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    6th July 2015 - 04:12 AM