Prev: Cant write to a file!!!
Next:
From: The Mad Ape on 11 Jun 2008 12:54
Hi

I have tables that I need to convert to dbf format from MS SQL Compact
2005 (sdf) format that reside on my desktop. I was hoping that I could
embed the utility and call it from some code I put behind a button.
Does anyone have anything like this or know where I can get it?

Thanks

The Mad Ape
From: Ginny Caughey MVP on 11 Jun 2008 13:06
Probably the easiest approach would be to write a desktop app that reads the
SDF file and uses the Visual Foxpro OleDb provider to write to the DBF file.
Alternatively you could use a 3rd party product like Codebase
(www.codebase.com) to work with the DBF files from a desktop app.

Ginny Caughey
Device Application Development MVP

"The Mad Ape" <chiefape(a)gmail.com> wrote in message
news:12f9c328-e008-4690-9401-26ef24d654a0(a)j22g2000hsf.googlegroups.com...
> Hi
>
> I have tables that I need to convert to dbf format from MS SQL Compact
> 2005 (sdf) format that reside on my desktop. I was hoping that I could
> embed the utility and call it from some code I put behind a button.
> Does anyone have anything like this or know where I can get it?
>
> Thanks
>
> The Mad Ape

From: Ginny Caughey MVP on 11 Jun 2008 15:29
Probably the easiest approach would be to write a desktop app that reads the
SDF file and uses the Visual Foxpro OleDb provider to write to the DBF file.
Alternatively you could use a 3rd party product like Codebase
(www.codebase.com) to work with the DBF files from a desktop app.

Ginny Caughey
Device Application Development MVP

"The Mad Ape" <chiefape(a)gmail.com> wrote in message
news:12f9c328-e008-4690-9401-26ef24d654a0(a)j22g2000hsf.googlegroups.com...
> Hi
>
> I have tables that I need to convert to dbf format from MS SQL Compact
> 2005 (sdf) format that reside on my desktop. I was hoping that I could
> embed the utility and call it from some code I put behind a button.
> Does anyone have anything like this or know where I can get it?
>
> Thanks
>
> The Mad Ape

From: Simon Hart [MVP] on 11 Jun 2008 16:09
As Ginny suggested, writing a desktop app that does the translation would be
the way I'd do it. Note I think it was from version 3.0 and onwards of SQL
Compact/CE you were able to read/write to compact databases. Previously, you
couldn't do this.
--
Simon Hart
Visual Developer - Device Application Development MVP
http://simonrhart.blogspot.com


"The Mad Ape" wrote:

> Hi
>
> I have tables that I need to convert to dbf format from MS SQL Compact
> 2005 (sdf) format that reside on my desktop. I was hoping that I could
> embed the utility and call it from some code I put behind a button.
> Does anyone have anything like this or know where I can get it?
>
> Thanks
>
> The Mad Ape
>
 | 
Pages: 1
Prev: Cant write to a file!!!
Next: