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

Tech-Archive recommends: Speed Up your PC by fixing your registry

This small piece of VBA code shows how to import all tables from an sdf file to a workbook: http://erikej.blogspot.com/2008/04/import-sql-compact-data-to-excel.html

--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

"Anthony Wieser" <newsgroups-sansspam@xxxxxxxxxxxxxxxxxxx> wrote in message news:uGf0yg4LJHA.5692@xxxxxxxxxxxxxxxxxxxxxxx
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: ssce3.5
    ... I have made a SqlCeBulkCopy .NET library, ... Erik Ejlskov Jensen, Mobile App Dev MCTS ... Check out my SQL Compact blog at ...
    (microsoft.public.sqlserver.ce)
  • Re: A fast way to delete all records
    ... there is no alternatives to the two methods you decribe. ... Erik Ejlskov Jensen, Mobile App Dev MCTS ... Check out my SQL Compact blog at ... is there any way faster than execute a DELETE FROM ...
    (microsoft.public.sqlserver.ce)
  • Re: Migrate from Access
    ... Erik Ejlskov Jensen, Mobile App Dev MCTS ... Check out my SQL Compact blog at ... Is tehere any tool for migrating from Access to SQLCe? ...
    (microsoft.public.sqlserver.ce)
  • Re: Errors using DEFAULT constraints
    ... Erik Ejlskov Jensen, Mobile App Dev MCTS ... Check out my SQL Compact blog at ... "Chris" wrote in message ...
    (microsoft.public.sqlserver.ce)