Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pass through query to txt file (2003)

    I am trying to export a pass through query to a text file and there are around 500,000 records. Is there anyway to do this all at once ? I ask because it says it can only copy so many records?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pass through query to txt file (2003)

    I'm sorry, I don't know, but wouldn't a text file with 500,000 records become unwieldy?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pass through query to txt file (2003)

    There is an access model that the queries are based off the text file that is produced. So once I can export the data into a text file I can link to an acess model where I am able to query the data from a form. Since I am new to pass through queries, I was not able to find a way to do another query that is based off the pass through query. Is there a way to do that? Because if I can do that my problem is solved.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pass through query to txt file (2003)

    Where do the original data reside? Oracle, SQL Server, something else?

  5. #5
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pass through query to txt file (2003)

    oracle

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pass through query to txt file (2003)

    I'd ask your Oracle DBA for a direct export from Oracle to a text file. That would be much more efficient than using Access as intermediary.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •