Help Connecting Excel and Access

[alfredo245]

Hi experts,

I have an access database with multiple queries. I am trying to make a connection between the database and Excel.

I am using the "Get External Data" option in the ribbon and selecting "From Access". After selecting the database, I select the query and select to export as a table. I am having problems with 1 particular query. When I export this query, I get an empty table in Excel with only 2 rows. I am not sure why this is happening as I have been able to export the other queries successfully.

Your help is greatly appreciated!

 

[James Deckert]

I'm trying to do what you're doing, but not getting the same prompts.
Are you trying to get Access data into Excel, or Excel data into Access?
The prompts you're getting sound like you're in Access, but why are you then choosing "From Access" instead of "From Excel"? Also why are you exporting instead of importing?

Confused

 

[Galaxiom]

Some Access queries just don't work in Excel. I recall some had problems with the Like operator not being applied to criteria but other just wouldn't return records. The tables were linked in Access from MS SQL Server.

I didn't investigate it further because the queries were just demos by a colleague, which I rebuilt as Views in the Server and connected directly to Excel.