How do I connect to access 2007 data from excel?

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
 
F

FSt1

hi
confused. if you are linked, then you are connected. ????
what are you trying/needing/wanting to do?

regards
FSt1
 
M

Marilyn Myers

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
 
B

Bob I

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
How do I save Pivot Table Data 4
Excel Template 13
Import data from Access 2007 1
How do I get running 12 months of data using date filter? 4
Access #Error & Excel Pivot 0
2007 Pivot Tbl to Access Conversion Issues 6

Top