Dries Hoebeke on .NETabout me and my life as a programmer

This is a very easy task lately that doesn’t require you to do any coding and/or thinking. However, one might think there is an export function in SQL Server Management Studio but this is not the case.

First, start off by opening a new Excell worksheet (i’m using Office 2007).

So we select “data” on the ribbon menu and then “from SQL server”.

Enter the location and name of your SQLExpress server.

Select the table which you want to import in Excel.

Now you can just click “next” and “finish” and there you have it folks; the table is nicely imported in Excel. Hassle free!

As always; hope this helps someone out!

After installing the ODBC driver for Advantage Database i couldn’t find the driver appear in the datasources managing program. After a bit of mandatory cursing and scouring around the web i found this is a pretty common problem when using a 32 bit driver on a 64 bit system.

It’s important to understand which kind of DSN you have. On an x64 system,
you can create an ODBC connection(DSN) on the 32-bit side of the system or
on the 64-bit side of the system.

32-bit applications will only see ODBC connections created in the 32-bit
side, and 64-bits applications will only see ODBC connections from the
64-bit side. Each kind of application has is own registry.

To setup DSN for 32-bit application you must use:
%WINDIR%\SysWOW64\odbcad32.exe
and for 64-bit application you must use:
%WINDIR%\System32\odbcad32.exe

Is what mister Charlie Russel has to say about this and it should help you fix the problem.

This opens a specific odbc datasources manager for 32 bit. Yes they are seperate from the 64 bit. Now after installing your datasource in the 32 bit manager it will also appear in the 64 bit manager allthough you can’t alter anything in the 64 manager.
Still, i think this is kind of lame from Microsoft to not include the 32-bit drivers in the program. I realise there’s probably a good reason for this but it would be nice to get a little more info about this after installing the driver.

Well, hope this solves somebody’s problem .