LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default HELP: Not able to generate query from excel for access 2007

Hi All,

I am trying to import data from access database to excel using Microsoft
query option in excel, but it doesnt allow getting data from access 2007
version which has .accdb extension. I am able to select the 2007 database by
selecting "All files" options but then it gives me an error "unrecognized
data format".

Can we not generate the query using Microsoft query option in excell for
access 2007?

Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using MS Query with Excel and Access 2007 mipoit Excel Discussion (Misc queries) 3 May 5th 09 01:58 AM
Excel 2007 - Query MS Access DB James C. Excel Discussion (Misc queries) 0 February 19th 09 03:34 PM
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Excel Discussion (Misc queries) 0 December 4th 08 05:57 PM
Import Access query to Excel 2007 Office Productivity Consultant Excel Discussion (Misc queries) 8 November 14th 08 05:52 PM
access-type query in excel 2007 newyorkjoy Excel Discussion (Misc queries) 1 August 2nd 07 05:43 PM


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"