Re: Can Excel 2007 get external data from an SDF file?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, I can see that you can poke data into excel from an external program (or is this a macro), but is it possible to connect directly using an OLE DB connection string?


"Ginny Caughey MVP" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message news:%23g1PrJ4LJHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
Anthony,

You can also load SQL CE data into Excel programmatically using Visual Studio Tools for Office. (VSTO). There's a sample here in the TechEd demos section: http://blogs.msdn.com/SteveLasker/

--

Ginny Caughey
Device Application Development MVP


.

Relevant Pages

  • Re: general macro question
    ... How is your external program launching excel? ... you'll have to load the addin ... when the external program launches excel it still doesnt show up. ... the macro menu option - I dont see any macro? ...
    (microsoft.public.excel.misc)
  • Updating worksheet without opening
    ... I have a bar coding program which refers to an Excel workbook as an ODBC ... the worksheet are not updated when the bar coding program accesses the ... Am I correct in thinking the external program is not actually ... (another reason I'm using an Excel sheet as my database) ...
    (microsoft.public.excel.misc)
  • RE: Locking a worksheet during the reading of it
    ... Excel Workbook which will be updated by an external program. ... I did not recommend you do that because Excel works ... as a desktop application which did not works smoothly in the multiple user ...
    (microsoft.public.excel.programming)
  • Re: How to start some file as Perl script argument?
    ... I want start perl script with XLS document as argument. ... I want star it with click on Excel document, How to do it in Windows OS? ... then you should have asked how to run an external program. ...
    (comp.lang.perl.misc)
  • Poking data from Excel into Access
    ... Its it possible to poke data from Excel xp in to Access ... xp db located on a network from a pc where the pc only ... has Office standard in install on it? ...
    (microsoft.public.excel.programming)