Access To SQL CE

[Jigabyte]

Hi Peeps,

I have a back office Access 2000 database and want to export some of the data into my SQL CE database which is being deployed to my PDA. Does anyone know of an easy or any way to do this?

Thank you all for any help,

Jiggy!

[petevick]

Export it to flat files and import it?
Web Service?
There is an Access synchronisation tool on the MS web site.

Pete

[easymoney]

I tried the Access Sync Tool, it must be above me. I could not get it to work, although others have.

Text files can be used also. I am using a delimited text file method, although told Xml would work as well. Not being used to Xml, delimited text seemed to be a good workaround for me.

[Shaggy Hiker]

Here's a link to a couple of links where I posted some of the code I use to do what you are talking about:

http://www.vbforums.com/showthread.p...&highlight=TCP

Basically, I turn the tables into XML, and send them over a TCP connection in a background thread.