Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Import (2003)

    I have an Excel file that I import into Access. The text fields default to 255. Is there any way (should I say an easy way) to reduce the size of the text fields. Once the file is imported, I make a copy of just the structure and change some of the text field sizes and then do an append query to load the data into the new structure.

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

    Re: File Import (2003)

    I'd do it like this:
    - Import to a new table once.
    - Adjust the field sizes of the new table.
    - Delete all existing records from the new table.
    - Import again, but now to the already existing empty table.

    If you need to do this more than once, you can link the Excel sheet in Access, and run a delete query on the new table followed by an append query from the linked Excel table to the new table.

Posting Permissions

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