MS query in excel 2007

[andycapp28]

Typical, I just get to grips with creating an excel msquery as data source/connection for a word mailmerge! What happens Office 2010 is installed, now they need a change and nothing works as the layout/familiarity with Excel 2007 is all over the place.
Does anyone know the way now to create a data connection (using excel file) in excel 2007?

Anyone out there maybe have how did in 2003 compared to how to do in excel 2007?

 

[SkipVought]

hi,

Data TAB > Get External Data GROUP

The choose which kind of source. THE ODBC sources are in From other sources.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[andycapp28]

Thanks for the fast response but I do not see External Data GROUP, other sources from Data menu.

Am I meant to change some of the excel options or something. The prompts are just so different to 2003.

 

[SkipVought]

In the Data TAB of the Excel 2007 ribbon, you should see GROUPS:

Get External Data
From Access
From Web
From Text
From Other Sources
Connections
Sort & Filter
Data Tools
Outline

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[andycapp28]

Got it,

Issue now us that the workbook I need to read was saved as a .xlsm file because it contains a VB macro. I am showstopped as the format required in MS query goes no higher level than have to be Excel 97-2000.

I will save file again as an Excel 97-2003.xls.

Thanks for now

 

[bubba100]

I use this to ease the frustration. By you using the "old way" this will show you the "new way".

http://www.microsoft.com/downloads/...2758-47b3-9f90-93788112b985&displaylang=en&tm