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

 

[beancounter]

The problem is receiving so much more than just the data. It is only in Excel 2010 where it returns the table, links and references, formating, etc. If you want to add a column for any reason to run a formula to calc various cells, the column has to be entered within the boundries of the table otherwise it won't reference the cells correctly.

It seems Microsoft anticipated people would use the exported data stictly as a table; or finished product. Whereby I use the data I export from various databases to link to and calculate and query. It is not a finished product after the export but the raw data to create a finished product.

John

 

[Norie]

John

I don't see why you couldn't add a column of formulas with the correct references.

If you really just want the data then perhaps there are other methods you could try to import the data.

 

[beancounter]

We have been utilizing ODBC & Excel for years and have dozens of querries at this point. I did the Marco and that seems to get me the data and leave the query in tack for refreshing.

 

[RonB1111]

To get rid of the "Table" style but still retain the data connection, click on any cell within the table, then in the Design Ribbon, click to open up the "Table Styles" (on the far right) and then click "Clear" button at the bottom of the window showing the various colors of tables.