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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
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:
    242
    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:
    245
    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,096
    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:
    224
    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:
    2,666
    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:
    341
    Douglas J. Steele
    May 27, 2006
  7. importing to temp table first

    , Jul 23, 2007, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    189
    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:
    399
    quintero
    May 26, 2008
Loading...