Excel 2010 odbc imports data in table???

[beancounter]

Does anyone know of a way to get the data from an ODBC query initiated via Excel to return the data as data? For instance, there are three options when importing data: Table, Pivot Table Report, or PivotChart and Pivot Table Report. I am looking to just get the data without any additional formatting/references etc.

Thanks,
John

 

[Norie]

John

Doesn't the table option return the data?

If it is formatted in some way, just remove the formatting after the import.

 

[beancounter]

I can't figure out how to remove the formatting.

 

[Norie]

If it is table formatting then right click Table>Convert to Range...

 

[beancounter]

I get the message "this will permanently remove the query definition from the sheet and convert the table to a normal range." and strips out the query so I can't refresh the data later.

I know in Excel 2003 & 2007 the data was returned as just data with no formatting and I could use the data to link to, sort, sum, etc. When it is in the table format I am severly limited as to what I can do with the data.

Perhaps in a future version the option will be available to just get the data and not the formatting.

Thanks for the responses I greatly appreciate the help,
John

 

[Norie]

John

If it is just the formatting you don't want then select the table, goto Clear>Clear Formats.

You can also turn off filtering on the Data tab.

 

[beancounter]

Where is "go to"?

 

[Norie]

There is no goto, I mean Clear in the Editing section of the Home tab.

 

[beancounter]

I see what you mean. Still added items that are difficult to work with. Such as, When you link to a cell - in the formula bar it reads, "=Table_Query_from_North[@[account_no]] rather than just "10097000" like the table displays.

Thanks again for the help. I read you can build a macro to copy data and paste special values & number formats onto a new tab and it will remove all the unwanted/useless junk. Going to give that a try.

Thanks again,
John

 

[Norie]

John

Is having the table references a problem?