Forum Discussion
Import from Access to Excel returns empty table.
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