PC Review

Thread Tools Rate Thread

Importing spreadsheet into a temp table locks the table

Joe Rich
Posts: n/a
      7th Jul 2003
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.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to Select * Into #temp From tblx and read #temp with ado. =?Utf-8?B?UmljaA==?= Microsoft ADO .NET 2 1st Oct 2006 09:24 PM
Importing cells into an excel spreadsheet from another spreadsheet pmelland@gmail.com Microsoft Excel Discussion 0 15th Aug 2006 08:54 PM
%temp% points to %systemroot%\temp instead of %userprofile%\LocalS~1\temp Gordon Fecyk Windows XP Setup 6 28th Mar 2005 09:53 PM
%temp% points to %systemroot%\temp instead of %userprofile%\LocalS~1\temp Gordon Fecyk Windows XP Security 6 28th Mar 2005 09:53 PM
Can I create temp table and update using temp table in same query? Microsoft Access 2 30th Oct 2003 02:41 PM




All times are GMT +1. The time now is 07:20 AM.