Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / December 2004

Tip: Looking for answers? Try searching our database.

Transfertext via Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John - 29 Dec 2004 14:31 GMT
Can someone help me please? I have a form in which I have placed a button
using the TransferText macro.

This is supposed to export a .txt/.csv. I have several queries which need to
be exported and they vary. Some are .csv some are .txt and some are tab
delimited and some are comma. Using the TransferText macro, there is no way
that you can control this as in the right click on query and export option.

Does any one have any ideas?

Many thanks
Ken Snell [MVP] - 29 Dec 2004 16:54 GMT
You control this in a macro by using different export specifications as
needed (they control the delimiter being used) and by using different
filenames for the output file (they control the file extension).

Are you wanting to use a single macro for all situations? Or can you have a
different macro for each situation?

Please provide more details about what you want to do.
Signature


       Ken Snell
<MS ACCESS MVP>

> Can someone help me please? I have a form in which I have placed a button
> using the TransferText macro.
[quoted text clipped - 10 lines]
>
> Many thanks
John - 30 Dec 2004 11:19 GMT
Thank you for your suggestion Ken. I have tried this but not gone far. I can
set a different macro for each of the files that's no problem. I am getting
stuck when it comes to the delimiters. Where do you say tab or comma
delimited? And where do you set where the fields have "" or not?

Can you give me a screen shot maybe? My email is elco2005@hotmail.com

Many thanks.

> You control this in a macro by using different export specifications as
> needed (they control the delimiter being used) and by using different
[quoted text clipped - 18 lines]
> >
> > Many thanks
Ken Snell [MVP] - 30 Dec 2004 15:14 GMT
You will need to create an export specification for each type of file. You
do this by manually beginning to export a table/query, and when the export
wizard window appears, go through all the steps until you get the last
screen (to do the actual export). On that screen, at lower left, you'll find
an Advanced button. Click that button. You'll get a screen that has all of
your settings displayed. Click the Save As button on that screen and choose
a name for the specification. Then you can cancel the export.

You then can use that specification in the TransferText action as the
SpecificationName argument.
Signature


       Ken Snell
<MS ACCESS MVP>

> Thank you for your suggestion Ken. I have tried this but not gone far. I
> can
[quoted text clipped - 32 lines]
>> >
>> > Many thanks
John - 30 Dec 2004 20:49 GMT
Many thanks for taking the time to help me Ken. A happy new year to you.

Regards,
John

> You will need to create an export specification for each type of file. You
> do this by manually beginning to export a table/query, and when the export
[quoted text clipped - 42 lines]
> >> >
> >> > Many thanks
Ken Snell [MVP] - 30 Dec 2004 21:03 GMT
You're welcome. Good luck.

Signature

       Ken Snell
<MS ACCESS MVP>

> Many thanks for taking the time to help me Ken. A happy new year to you.
>
> Regards,
> John
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.