Importing data from Access into Excel

Giganews Newsgroups
Subject: Importing data from Access into Excel
Posted by:  Jan Kronsell (kronsell(removebeforesend)
Date: Mon, 24 May 2004

I try to import data from an Access qury into my spreadsheet. And it owkrs
perfectly ok, umles the query in Access has a criteria, using the keyword
Like (Like pres*"). In this case no data is imported to Excel, only the
field names. And yes, running the query in Access, does return data :-)

I can make a new database query from Excel, at that works, but why doesn't
it work the other way around. Any ideas of how to get this to work.