dev
2009-08-17 20:54:01 UTC
I am trying to connect and query data into Excel and/or MS Access from a
newly installed/created sql server compact instance and I seem to get
nowhere. The only thing that works is the 2008 SQL Management Studio and VS
2008 but I would like to perform simple data entry in MS Access via linked
tables and query data for simple reports into Excel.
There is no OLE DB provider showing in any of the data connection screens
(neither via Excel nor anywhere else in the non-Visual Studio/ssms world).
Am I doing something wrong ?
The O/S is Vista 64bit.
Thanks
newly installed/created sql server compact instance and I seem to get
nowhere. The only thing that works is the 2008 SQL Management Studio and VS
2008 but I would like to perform simple data entry in MS Access via linked
tables and query data for simple reports into Excel.
There is no OLE DB provider showing in any of the data connection screens
(neither via Excel nor anywhere else in the non-Visual Studio/ssms world).
Am I doing something wrong ?
The O/S is Vista 64bit.
Thanks