
September 14th, 2004, 02:47 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
From comma delimited to tab delimited
I am exporting data from Oracle through Access as comma delimited and I need tab delimited. The code that I have is:
Private Sub ActRateExp_Click()
DoCmd.TransferText acExportDelim, , "Act_Unit_Rate", "c:\temp\vendor\ActratePerDay.txt", True
DoCmd.TransferText acExportDelim, , "Activity Standard", "c:\temp\vendor\ActrateStnd.txt", True
DoCmd.RunMacro "CompleteMessage"
End Sub
Can anyone help?
|