Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export table or query to excel (Access 2000/SR-1)

    Hi:

    Is there a problem with exporting to an excel file with a table or query that contains a number with the field size a decimal??

    Example: We extract data from an oracle database and within certain tables there are latitudes and longitudes. When this data is extracted the default settings for these fields are datatype = number, field size = decimal, and precision = 9, scale = 3.

    When we use the export, it comes up with an error message "Invalid Argument".

    Is there a work around this???

    Thank you for you help in advance.

    Janet

  2. #2
    Star Lounger
    Join Date
    Oct 2001
    Location
    Western Massachusetts, USA
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export table or query to excel (Access 2000/SR-1)

    There shouldn't be. Can you post your Export code. The InValid Argument shouldn't have anything to do with the Table values you've set.
    Paul

Posting Permissions

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