Results 1 to 7 of 7
  1. #1
    Michael T is offline Novice
    Windows Vista Access 2003
    Join Date
    Nov 2011
    Posts
    16

    Export to txt not working

    Hi,



    I'm creating a macro to output to txt but I get lots of dashes and pipes rather than a comma delimited file, can anyone help please?

    Michael

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    could you show the macro please.

    Are you trying to do a transfertxt on a query or export a table or...?

  3. #3
    Michael T is offline Novice
    Windows Vista Access 2003
    Join Date
    Nov 2011
    Posts
    16
    Sorry, I'm using a macro with the outputTo action.

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Please list the macro exactly as you are trying to use it, ie the macro name and the parameters.

  5. #5
    Michael T is offline Novice
    Windows Vista Access 2003
    Join Date
    Nov 2011
    Posts
    16
    The macro is called: 07 Create Verified correct txt file

    Its and outputTo action

    Here are the parameters

    object type = Table
    object name = RE Constit and Addr Fields Addr Ver Correct
    output format = Text Files(*.txt)
    outputfile = C:\QAS\QAS October 2011\Adress Cleaning DB\to Import onto RE\verified correct.txt
    autostart = No
    Template file = (is blank)
    Encoding = (is blank)

    Thanks

  6. #6
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    You probably need to use Transfertxt instead of outputto.

    Google the Access TransferTxt method

  7. #7
    Michael T is offline Novice
    Windows Vista Access 2003
    Join Date
    Nov 2011
    Posts
    16
    That works a treat. Thanks for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export more than 70000
    By waqas in forum Programming
    Replies: 5
    Last Post: 09-13-2011, 01:43 PM
  2. CSV Export
    By mchadwick in forum Access
    Replies: 1
    Last Post: 09-06-2011, 03:19 PM
  3. Excel Export Tab Name
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 06-28-2011, 08:36 AM
  4. Export
    By vvasudev in forum Import/Export Data
    Replies: 2
    Last Post: 01-20-2010, 11:42 AM
  5. Export to MySQL
    By avincent in forum Import/Export Data
    Replies: 1
    Last Post: 12-19-2009, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums