Access Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger D - 14 Jun 2007 16:09 GMT

Hello,

I have an Excel spreadsheet I use for a database. I am trying to make a
form in Access to make data entry easier.

When I open the spreadsheet in Access and make a columnar form and try to
input data, I cannot change any of the entries or input new data. The add
record button is also grayed out.

Thanks

Roger Dahl

Reply to this Message

Roger Carlson - 14 Jun 2007 16:26 GMT

As a result of a lawsuit against Microsoft, you can no longer update linked
Excel files. I believe this only affects Access 2003 and above.

Signature

--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> Hello,
>
[quoted text clipped - 8 lines]
>
> Roger Dahl

Reply to this Message

SusanV - 14 Jun 2007 16:29 GMT

Hi Roger,

You're right - you can't edit data in an Excel sheet linked into Access:
http://support.microsoft.com/kb/904953/en-us

A workaround might be to import the data, manipulate it, then output it back
to the excel sheet.

Signature

hth,
SusanV

> Hello,
>
[quoted text clipped - 8 lines]
>
> Roger Dahl

Reply to this Message

Roger D - 15 Jun 2007 04:26 GMT

I just want to use Access because the input forms are easier to use, and I
can rearrange the sequence of input. If I open an excel file with the data I
want, can I delete the link and then input into the access table?

Roger D

> Hi Roger,
>
[quoted text clipped - 15 lines]
> >
> > Roger Dahl

Reply to this Message

SusanV - 15 Jun 2007 12:12 GMT

Not sure what you mean by open the file and delete the link - if you open
the linked table you can't very well delete the link to the spreadsheet
while it's open...

>I just want to use Access because the input forms are easier to use, and I
> can rearrange the sequence of input. If I open an excel file with the
[quoted text clipped - 26 lines]
>> >
>> > Roger Dahl

Reply to this Message