Results 1 to 2 of 2
  1. #1
    BillyMo11
    Guest

    Exporting from a Linked Table (Access 2000)

    I am trying to export data from a table that is linked in access to a table in oracle, and when try to export the data to a fixed width file it gives me an error of 'Invalid Arguments', with no error number and no help on where the error is coming from.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Exporting from a Linked Table (Access 2000)

    Are you trying to do this using VBA, or are you using the export wizard? If it's coming from the wizard, you may have entered a value that doesn't make sense to it. On the other hand if it's VBA giving you that error, you may have other problems.

    One issue to consider is that you may be exceeding a limit if the Oracle table contains a "Blob" field that can be very large. You might try exporting to a delimited text file to see if that works. Hope this helps.
    Wendell

Posting Permissions

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