Importing Excel data into a Read Only Access file

Hi,

I have a read only access file with a linked table that connects to a
sybase database. So I can still add data to the table even though its
read only since the table is really in sybase. However, I want to
import data from an excel file (either via a macro in excel or access)
but I always get an "Error 3051" because the access file is read
only. Does anyone know a good workaround to this? I've been using the
TransferSpreadsheet method to no avail.

Thanks.

re: Importing Excel data into a Read Only Access file

"greg" <greg.ng@gmail.comwrote
As far as I know, "Read Only" means "Read Only". My only suggestion is to
reset that option to allow writing, import the data, then reset again to
Read Only. Frankly, I don't recall ever having worked with a "Read Only"
Access DB... though I know there are occasions when they are appropriate.

Larry Linson
Microsoft Access MVP

re: Importing Excel data into a Read Only Access file

I know its a strange request, but unfortunately necessary for work
related reason. Thanks.

On Apr 13, 8:15 pm, "Larry Linson" <boun...@localhost.notwrote:

re: Importing Excel data into a Read Only Access file

If it is to be read-only, have you considered linking your Access DB to the
Excel spreadsheet?

Unfortunately, if the entire Access DB is "read-only", that blocks any
possibility that I can imagine to _import_ anything. If it did not, then
"read-only" would be a misnomer.

Larry Linson
Microsoft Access MVP


"greg" <greg.ng@gmail.comwrote in message
news:1176750299.180177.38100@b75g2000hsg.googlegro ups.com...

re: Importing Excel data into a Read Only Access file

Using a linked table to excel is another possibility. Right now I am
exploring creating another Access DB that is read/write to import the
data. It seems to work so far, however it isn't terribly fast.