|
Home > Archive > MS SQLCE > October 2005 > Export Data from CE to text/excel file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| 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 ***
|
|
|
|
|