How do I connect to access 2007 data from excel?

  • Thread starter Thread starter Marilyn Myers
  • Start date Start date
M

Marilyn Myers

I have a link to Excel 2007 data in Access 2007 and when changes are made in
Excel... Access is updated. I have tried to connect to Access data from
Excel and the query I need is not an option. What am I doing wrong? (P.S. I
am really new to Access and I am not a programmer.) Any help is greatly
appreciated.
Thanks,
Marilyn
 
hi
confused. if you are linked, then you are connected. ????
what are you trying/needing/wanting to do?

regards
FSt1
 
Sorry about the confusion!! From Excel 2007: Data, External Data, From
Access, Select Data Source....My Access 2007 Database is not listed. I have
two queries in Access that I want to connect to to create a chart and have
the info updated when changes are made in Access. I have "Access 2007 for
Dummies" and it stated to create charts in Excel instead of Access. Why does
Access not show up in Select Data Source?
Thanks
Marilyn
 
You will need to navigate to and show the contents of the folder that
your Access file is in.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting query data from Access 1
Opening excel 2010 spreadsheet from Access 4
Import data from Access 2007 1
How do I save Pivot Table Data 4
Excel Template 13
Access #Error & Excel Pivot 0
How do I get running 12 months of data using date filter? 4
edit query in Escel 2007 pulled from Access? 1

Back
Top