Home

Import from Access to Excel returns empty table.

%3CLINGO-SUB%20id%3D%22lingo-sub-325752%22%20slang%3D%22en-US%22%3EImport%20from%20Access%20to%20Excel%20returns%20empty%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325752%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EWhen%20linking%20an%20access%20query%20to%20excel%20using%20method%20Data%26gt%3BGet%20Data%26gt%3B%20From%20Database%26gt%3B%20From%20Microsoft%20Access%20Database%2C%20the%20table%20in%20Excel%20returns%20the%20column%20headers%20but%20no%20other%20data.%3C%2FP%3E%3CP%3EWhen%20I%20got%20to%20Access%20to%20check%20the%20table%2C%20everything%20there%20seems%20fine.%20Any%20suggestions%3F%3C%2FP%3E%3CP%3EI'm%20using%20Access%20%26amp%3B%20Excel%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-325752%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769734%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20from%20Access%20to%20Excel%20returns%20empty%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272218%22%20target%3D%22_blank%22%3E%40_july_cesar%3C%2FA%3EI%20am%20experiencing%20the%20same%20issues.%26nbsp%3B%20It's%20only%20with%20one%20particular%20set%20of%20queries%20though.%26nbsp%3B%20There%20are%20three%20levels%20to%20the%20query%20and%20only%20the%20first%20level%20query%20will%20show%20data%20within%20Excel.%26nbsp%3B%20All%20other%20queries%20from%20the%20same%20Access%20database%20import%20into%20Excel%20fine.%26nbsp%3B%20There%20is%20no%20out%20of%20the%20ordinary%20criteria%20set%20in%20the%20Access%20queries.%26nbsp%3B%20I'm%20completely%20at%20a%20loss%20on%20this%20one.%20I'm%20on%20O365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327212%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20from%20Access%20to%20Excel%20returns%20empty%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327212%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20July%2C%20do%20you%20have%20any%20criteria%20when%20requesting%20data%20from%20Access%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
_july_cesar
Occasional Visitor

Hello.

When linking an access query to excel using method Data>Get Data> From Database> From Microsoft Access Database, the table in Excel returns the column headers but no other data.

When I got to Access to check the table, everything there seems fine. Any suggestions?

I'm using Access & Excel 2016.

3 Replies

Hi July, do you have any criteria when requesting data from Access?

@_july_cesarI am experiencing the same issues.  It's only with one particular set of queries though.  There are three levels to the query and only the first level query will show data within Excel.  All other queries from the same Access database import into Excel fine.  There is no out of the ordinary criteria set in the Access queries.  I'm completely at a loss on this one. I'm on O365.

@_july_cesar 

 

Your now executing a query and importing the results in Excel if I am correctly.

There can go two things wrong, the execution of the query is not working when using this import from Excel or the importfunction from Excel gives the problem.

 

In order to solve this I need of course more information but what you can do is to change your query to a maketable query and try to import the created table. With this you can rule out that the import is the cause of the problem.

 

Furhermore you can look into the options while importing. I am not importing much from Access to Excel so don't know exactly what the options are but mostly it asks to convert fieldnames to rows or not where can be some problems. Also you can have a problem with field properties. If one field is giving a text in a numeric cell it can have problems to complete the import. 

I have about 20 years experience with office (and VBA) and had only few times a situation that I needed to import to Excel so I do this from some grey memories :))

 

Greetings,

Marcel

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies