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

    Import an Excel file (2003)

    I imported an Excel file into Access. I opened the table in design mode so I could reduce the length of some of the text fields. I go to save the table and it says I don't have enough memory. I was going to close everything that was open and then reboot. Will this be enough to let me change the field lengths and save the table? It has over 200,000 records.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel file (2003)

    Depends on your system, really. If that doesn't work, you can always import the Excel file in pieces, and then use a make-table query.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel file (2003)

    I'm sorry, I completely misread what you'd stated. Could you create a duplicate table w/o any records but formatted correctly, and then use an update query to move all the records?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel file (2003)

    What do you mean by - you can always import the Excel file in pieces, and then use a make-table query.

    I imported the Excel file into Access. I created a query where I use the Excel file and another linked Oracle table. I make this query into a table. In this table, I am trying to change the text field sizes from the default to a more manageable field size. I compacted, rebooted, closed everything but Access and I still get that not enough memory when I change even one field.

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

    Re: Import an Excel file (2003)

    I copied the table and changed the field sizes. Now do I bring the original table into a query and change it to an update query. Would I bring in all the fields and where it says update to would I put the new table name? What is the syntax for the update table?

    I am not sure how to get the data back into the empty table?

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel file (2003)

    I take that back, an append query will do what you're trying to quicker (assuming to create the new table, you copied the structure of the old, and then modified the field to suit you). Open a query in design view, and select your original table. Then change the query to an append query, and select your new table as the destination to append to. Drag the asterisk to the query data box, and the click the exclamation point. Hopefully that's clear enough, I'm a much more visual person.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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