468,791 Members | 1,794 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,791 developers. It's quick & easy.

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.

Apr 13 '07 #1
4 5228
"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
Apr 14 '07 #2

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:
"greg" <greg...@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

Apr 16 '07 #3
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" <boun...@localhost.notwrote:
>"greg" <greg...@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


Apr 16 '07 #4

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.

Apr 18 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
9 posts views Thread by jillandgordon | last post: by
5 posts views Thread by hharriel | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.