Using Access to input data in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need help for using access to maintain the data in excel. I have imported
the excel sheet to access with a link, but then access won't allow me to
change the data.

thanks for any tips,
venkoli
 
venkoli said:
Hi,
I need help for using access to maintain the data in excel. I have
imported
the excel sheet to access with a link, but then access won't allow me to
change the data.

thanks for any tips,
venkoli
Click to expand...

Do you have permissions to edit the file at folder/file level? Does someone
have the spreadsheet open?

Keith.
www.keithwilby.com
 
What version of Access? The ability to update Excel from Access was recently
removed from both Access 2002 and Access 2003, due to Microsoft losing a
lawsuit.
 
So that's the reason, I have Access 2003.
Is there any other way to move the data from access to existing sheet in
excel?

//venkoli
 
Douglas J Steele said:
What version of Access? The ability to update Excel from Access was
recently
removed from both Access 2002 and Access 2003, due to Microsoft losing a
lawsuit.
Click to expand...

I use Office 2k3 and can update Excel from Access - is this a territorial
thing? If I lose the ability to do this then our weekly metrics reporting
will be up the creek.

Keith.
 
Keith Wilby said:
I use Office 2k3 and can update Excel from Access - is this a territorial
thing? If I lose the ability to do this then our weekly metrics reporting
will be up the creek.
Click to expand...

You obviously haven't had all of the service packs installed.
 
Douglas J Steele said:
You obviously haven't had all of the service packs installed.
Click to expand...

We're on SP1. What possible "legal issues" can there be to stop two MS
products from communicating with each other?

You mention using automation in another posting, do you have any working
examples you could perhaps post the code for (automation is not something
I've used before)?

Many thanks,
Keith.
 
Keith Wilby said:
We're on SP1. What possible "legal issues" can there be to stop two MS
products from communicating with each other?
Click to expand...

See
http://news.com.com/Patent+ruling+costs+Microsoft+8.9+million/2100-1007_3-5735432.html
for details.
You mention using automation in another posting, do you have any working
examples you could perhaps post the code for (automation is not something
I've used before)?
Click to expand...

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html
 
Douglas J. Steele said:
You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html
Click to expand...

Doug,

This is an excellent example, many thanks indeed. The routine I currently
run populates an Excel spreadsheet for production of metrics graphs. Do you
have any examples of code that writes data to Excel or know of any sites
with examples? Thanks for your patience, this is all new to me.

Regards,
Keith.
 
Keith Wilby said:
Doug,

This is an excellent example, many thanks indeed. The routine I currently
run populates an Excel spreadsheet for production of metrics graphs. Do you
have any examples of code that writes data to Excel or know of any sites
with examples? Thanks for your patience, this is all new to me.
Click to expand...

I thought my article did that...

What more do you need? (I've done exactly what you're trying to do, getting
my data from SQL Server)
 
Douglas J Steele said:
I thought my article did that...
Click to expand...

It does. Trying to run before I can walk but I've got the hang of it now.
Thanks again Doug.

Keith.
 
Back
Top