hondaman2003
Programmer
I have an access database that has a link to a spreadsheet. I can open the spreadsheet directly and modify it anyway i want, but I cannot open it via the link in the database, the data comes up read only. What is wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS access linked table to excel file is read only 1
- Thread starter hondaman2003
- Start date
- Status
Hi Honda,
I take it you're using Access 2003?
If so, then this Excel edit feature was allegedly removed in 2003.
Why are you using Excel as your data store - why not a database?
Excel is good for 'scratch-pad' and reporting - not long-term storage of data.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
I take it you're using Access 2003?
If so, then this Excel edit feature was allegedly removed in 2003.
Why are you using Excel as your data store - why not a database?
Excel is good for 'scratch-pad' and reporting - not long-term storage of data.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
- Thread starter
- #3
hondaman2003
Programmer
What if I am using access 2002 with excel 2003?
I didn't build the database or spreadsheet. I'm sort of jumping into this in the middle and may not have time to deal with it.
I didn't build the database or spreadsheet. I'm sort of jumping into this in the middle and may not have time to deal with it.
Honda,
Sorry, I believe this was removed for 2002 - on.
Dependant on the extent of formatting in your Excel spreadsheet - you could:
1) Link to it with Access
2) Import the data into a table
3) Manipulate the data
4) Export the table as Excel.
Or, drive the transaction with Excel, which would link to Access - get's it's required data and update it's own cells.
(In that case - try the Excel or VBA forums for VBA code to do so).
Don't think there are many other options.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
Sorry, I believe this was removed for 2002 - on.
Dependant on the extent of formatting in your Excel spreadsheet - you could:
1) Link to it with Access
2) Import the data into a table
3) Manipulate the data
4) Export the table as Excel.
Or, drive the transaction with Excel, which would link to Access - get's it's required data and update it's own cells.
(In that case - try the Excel or VBA forums for VBA code to do so).
Don't think there are many other options.
ATB
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
-
1
- #5
- Thread starter
- #6
hondaman2003
Programmer
pwise, thank you for that!!! Its working now. I can modify the spreadsheet and run queries and do other things just as if it was a linked table now.
Thank you Darrylles for attempts to help me also.
I am going to be fixing this so it's not linking with a spreadsheet and have the database import the data into a table directly but for now I have it working till I have time to deal with it.
Thank you Darrylles for attempts to help me also.
I am going to be fixing this so it's not linking with a spreadsheet and have the database import the data into a table directly but for now I have it working till I have time to deal with it.
- Status
Similar threads
