MS SQLCE - Export Data from CE to text/excel file

Author

Export Data from CE to text/excel file

IT Marquis

2005-09-28, 3:24 am

Dear Sir/Madam,

I have a SQL CE database and I can use SQL CE Query Analyser to view
the table with SQL statement.

However, I would like to ask whether there is SQL statement or Method
that I can extract the data from SQL CE DB to text file at Pocket PC.

Thanks for your kind attention.

IT Marquis

Darren Shaffer

2005-09-30, 8:23 pm

you can write a simple compact framework application that
connects to your SQL CE database, selects the data you want
to export, and as you iterate through the resulting SqlCeDataReader,
writes to a file on device. pertinent namespaces are:

System.IO
System.Data
System.Data.SqlServerCe
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"IT Marquis" <bso@hkland.com> wrote in message
news:1127877278.471427.183960@o13g2000cwo.googlegroups.com...
> Dear Sir/Madam,
>
> I have a SQL CE database and I can use SQL CE Query Analyser to view
> the table with SQL statement.
>
> However, I would like to ask whether there is SQL statement or Method
> that I can extract the data from SQL CE DB to text file at Pocket PC.
>
> Thanks for your kind attention.
>
> IT Marquis
>

IT Marquis

2005-10-03, 3:23 am

Hi Darren Shaffer,

Thanks. Do you have sample code so that I can extract data from CE
database to a text file/ exel file at CE platform.

From your suggestion, that means, there is no way at SQL CE QA so that I
can write script to export that data from table to text file ?!

AT SQL Server 2000 QA, we can use xp_cmdshell to do the export. Are
there any similar function and sample code at SQL CE QA ?!

Thanks.

IT Marquis

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links