Importing spreadsheet into a temp table locks the table

Discussion in 'Microsoft Access External Data' started by Joe Rich, Jul 7, 2003.

  1. Joe Rich

    Joe Rich Guest

    I am importing data into a temp table from which I move it
    into ListView. Before the import, I check to see if the
    table exists. If so I delete it. Then use the
    TransferSpreadsheet command to recreate it.

    This works the first time. However, the second time i try
    to import the spreadsheet, when I attempt to delete the
    temp table, I get a Error 3211 (table in use). It appears
    at though anytime I use TransferSpreadsheet to import data
    into a table, that table is locked and cannot be unlocked
    except by exiting ACCESS. No other user has acccess to
    this temp table. Can this be the case? Is there a way to
    tell ACCESS to unlock that table?

    PS. I have tried to use the acLINK option rather than the
    acIMPORT, but then I get a message saying the linked file
    is locked and the link cannot be deleted.
     
    Joe Rich, Jul 7, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. barry sharp

    Importing XLS spreadsheet into access database

    barry sharp, Feb 17, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    269
    Joan Wild
    Feb 17, 2004
  2. Alex Saager

    Importing an excel spreadsheet into Access

    Alex Saager, May 28, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    294
    Ken Snell
    May 28, 2004
  3. Andrew Good

    Importing Excel spreadsheet into Access - data type problem

    Andrew Good, Aug 26, 2004, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    1,273
    Jamie Collins
    Aug 27, 2004
  4. Guest

    Importing Excell Spreadsheet into Access

    Guest, Aug 22, 2005, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    250
    Guest
    Aug 22, 2005
  5. Guest

    Preserving Excel Formulas while importing spreadsheet into Access

    Guest, Jan 24, 2006, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    4,445
    Douglas J. Steele
    Jan 26, 2006
  6. jwr

    Importing Spreadsheet/Linking spreadsheet

    jwr, May 25, 2006, in forum: Microsoft Access External Data
    Replies:
    7
    Views:
    384
    Douglas J. Steele
    May 27, 2006
  7. importing to temp table first

    , Jul 23, 2007, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    210
    Guest
    Jul 23, 2007
  8. Shawky

    Extracting data from one table into a temp table

    Shawky, May 1, 2008, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    432
    quintero
    May 26, 2008
Loading...