Replication of Access Database with SDF

E

Enver A

Anyone can tell me how to copy certain amounts of data (max 1500 records)
from access database to SDF (SQLCE Server database)?
 
G

Ginny Caughey [MVP]

Enver,

One approach would be to export the Access data to XML (or CSV) and copy it
to the device. Then on the device, import the XML (or CSV using the CSV data
adapter on www.opennetcf.org) into a dataset, and then use the dataset to
programmatically set up the SqlCe database. There are also 3rd party
products such as RemoteSqlCe that you can use:
http://www.gui-innovations.com/html/remotesqlce.html

--
Ginny Caughey
..Net Compact Framework MVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify sdf database on a desktop application 4
SDF Database 4
Reading MS SQL Server CE SDF files on full framework 2
copy table from sdf file to another sdf file 2
Creation of a sample database in SQL Moblie - steps required 1
HOW TO LOAD *.SDF DURING THE TEST DATABASE APPLICATION IN WM 5.0 1
MDB to SDF??? 2
How to make a local database 8

Top