change output object to tab delimited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently under "design view", under "Macros", I have an "output to" record.
The "output type" has limited options, and I need to get this changed to "tab
delimited format". Please could someone offer some assistance, as I have
found nothing on the net. Thanks
 
Richard,

I suggest you have a look at the TransferText action, instead of OutputTo.

Go through your output procedure first, manualy, via the File|Export
menu, and when you get to the final screen of the export wizard, click
the 'Advanced' button, where you will be able to save your setup
(including the Tab delimiter) as a Specification. Then, enter this
specification in your macro, in the Specification Name argument of the
TransferText action.
 
Hi Steve

Thanks for the help. I did what you instructed and its working 99% right
now. The file exports no problem, but now I have a new problem, which seems
to be linked to the "transfertext"..

Before the "OutputTo" had an "autostart" feature which automatically opened
the file once the data was exported... now the "autostart" option is not
there. It is an essential part of the process that the file is opened once
the data has been exported. Please could you offer some advice.. thanks so
much, kind regards, Richard (South Africa)
 
Richard,

You will be able to use a RunApp action at the end of your macro to open
the file. Assuming it is to be opened with Notepad, the Command Line
argument of the RunApp will be something like this...
"C:\Windows\Notepad.exe" "C:\YourFolder\YourFile.txt"
 
Hi Steve

Thanks very much for all your help. Thanks to you I have been able to get it
all working 100%. I needed EXCEL to open the txt file, so I changed one or
two things, but its all working great.

Thanks very much again, I will be coming back HERE if I ever need help with
Access again.

Kind Regards,
Richard
 
Hi Steve

Didnt think I would be checking in so soon again...

At the moment everything works 100%, would just like to streamline my
process some more...

Right now the query connects to a SQL Database. So EVERYTIME I run the
query, it prompts me for the user and password for the SQL server I connect
to (local). Simply put, I need to untick the "Use Trusted Connection" and put
in my user and password each and everytime. This is extremely time consuming,
and not productive. Ive read on the net that it cant be changed, is this
true?? Some help would be great... thanks.

Kind regards,
Richard
 
Very good, Richard.

I didn't realise you were outputting for Excel. In that case, it may
have been more appropriate to be looking at the TransferSpreadsheet
action rather than TransferText - but then I can't see where the
requirement for the Tab delimiter comes into it if you are opening it in
a spreadsheet.
 
Richard,

How are you connecting to the SQL Server database? Linked tables via ODBC?

I notice you have also multi-posted your question to the security
newsgroupo, so I will keep an eye over there.
 
Back
Top