change output object to tab delimited

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard (South Africa) - 20 Sep 2006 12:41 GMT

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

Reply to this Message

Steve Schapel - 20 Sep 2006 20:10 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message

Richard (South Africa) - 26 Sep 2006 12:10 GMT

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,
>
[quoted text clipped - 11 lines]
> > delimited format". Please could someone offer some assistance, as I have
> > found nothing on the net. Thanks

Reply to this Message

Steve Schapel - 27 Sep 2006 01:28 GMT

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"

Signature

Steve Schapel, Microsoft Access MVP

> Hi Steve
>
[quoted text clipped - 7 lines]
> the data has been exported. Please could you offer some advice.. thanks so
> much, kind regards, Richard (South Africa)

Reply to this Message

Richard (South Africa) - 27 Sep 2006 10:55 GMT

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

> Richard,
>
[quoted text clipped - 14 lines]
> > the data has been exported. Please could you offer some advice.. thanks so
> > much, kind regards, Richard (South Africa)

Reply to this Message

Steve Schapel - 27 Sep 2006 21:03 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> Hi Steve
>
[quoted text clipped - 4 lines]
> Thanks very much again, I will be coming back HERE if I ever need help with
> Access again.

Reply to this Message

Richard (South Africa) - 27 Sep 2006 15:09 GMT

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

> Richard,
>
[quoted text clipped - 14 lines]
> > the data has been exported. Please could you offer some advice.. thanks so
> > much, kind regards, Richard (South Africa)

Reply to this Message

Steve Schapel - 28 Sep 2006 02:42 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> Hi Steve
>
[quoted text clipped - 9 lines]
> and not productive. Ive read on the net that it cant be changed, is this
> true?? Some help would be great... thanks.

Reply to this Message