Importing data from Access into Excel

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

Jan Kronsell

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.

Jan
 
Hi

A couple of suggestions:
1 Save the query in Access, then try right-clicking on it and select
Export. You can then export it as an Excel sheet.
2 Run the query in Access, and go to Edit / Select all. As long as there
isn't tons of data you should then be able to copy this and paste it into
Excel.

Do either of these options work for you? Do you get the same results? I
can't think of why your problem occurs.
By the way, after using the second method above, you will probably need to
switch off Word Wrap in the cells in Excel.
 
Thanks but I have figured it out. Its the wildcard causing the trouble.
MSquery expects % as wildcard. So if i set the criteria

Like 'pres%' the query works perfectly when I import into Excel. The same
query cannot be run in access then, but thats another matter.

Your suggestions works ok, though. iIhave tried them both, but neither is
possible solutions, as Access needs to be run invisible form the user.

Jan
 
Back
Top