Importing Excel data into a Read Only Access file

[greg]

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.

[Larry Linson]

"greg" <gr*****@gmail.comwrote

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.

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

[greg]

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

On Apr 13, 8:15 pm, "Larry Linson" <[e-mail]:

"greg" <[e-mail]

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.

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

[Larry Linson]

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" <gr*****@gmail.comwrote in message
news:11*********************@b75g2000hsg.googlegro ups.com...

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

On Apr 13, 8:15 pm, "Larry Linson" <[e-mail]:

>"greg" <[e-mail]

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.

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

[greg]

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.