Access Form

[Roger D]

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

 

[Roger Carlson]

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.

--
--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

 

[SusanV]

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.

 

[Roger D]

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

 

[SusanV]

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...