SQL querying Excel 2010 lists, or something else ...

lalbatros

Well-known Member
Joined
Sep 5, 2007
Messages
659
Hello,

I remember the old time when I tried to use SQL queries on Excel 2003 tables.
This was possible but mainly from one workbook to another, otherwise there were problems which I do not remember well. Using SQL queries from one workbook to another one also caused problems when moving files from a folder to another because the path was hard coded by Microsoft Query. All in all, I gave up this idea.

Today, as I am using Excel 2010 more and more, I wonder if there is progress on this topic.
Have some of you tested any possibility to use SQL queries within an Excel workbook?

Alternatively, have you found other ways to manipulate data in Excel without "micro-controlling" the logic on the individual cell level? Maybe LINQ in a VSTO project? Maybe something simpler?

Thanks for your suggestions,

Michel
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

lalbatros

Well-known Member
Joined
Sep 5, 2007
Messages
659
I had a look around on Excel 2010.
It seems that "Microsoft Query" is still there and is still the only tool to query data sources.
Behind the skin, still the old stuff.

Any suggestion?

Probably no change on the VBA side ?
Should I give a try to some VSTO programming ? LINQ ?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,489
Messages
5,601,986
Members
414,489
Latest member
Xlambda

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top