Access Query as Excel Data - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Query as Excel Data

Walter Hamilton

5 years ago

I'm trying to use an Access Query as an External Data Source for Excel. The Query doesn't show up as available within Excel but other queries do. I'll attached a screen shot of the list of queries within the Access Database and another of the list of queries available within Excel.

	Walter Hamilton OP @Reply 5 years ago

	Walter Hamilton OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
What kind of a query is it? Queries with complicated calculations, aggregate queries, etc. won't always show up as visible to Excel because Access has to perform those computations. You may have to create a Make Table query first then pull that into Excel.

	Walter Hamilton OP @Reply 5 years ago
Richard, The query has a lot of helper tables in it. I'll attempt the Make Table query and see if that works. Thanks for the assistance.

Walter Hamilton OP @Reply

5 years ago

Richard,

I was able to build a Make Table query and link it to excel. The problem I'm having now is I get an error back saying the database has been placed in a state by user "Admin" on machine 'my computer name' that prevents it from being opened or locked.

I can open the database with the excel spreadsheet open, close the database and then update the record source but I can't open the excel spreadsheet with the database closed and update the record source.

	Richard Rost @Reply 5 years ago
Once you've created the table, export it as a CSV file. That may work better in Excel.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View